21 Aug
|
Su0026P Global Market Intelligence
|
Bengaluru
21 Aug
Su0026P Global Market Intelligence
Bengaluru
Job Summary
Grade Level (for internal use): 11
The Role: Database Architect.
The Team: We are looking for a highly self-motivated hands-on Database Architect who would focus on our database infrastructures estate and automations and DevOps engineering within our enterprise solutions division.
The Impact: This is an excellent opportunity to join Enterprise Solutions as we transform and harmonize our infrastructure into a unified place while also developing your skills and furthering your career as we plan to power the markets of the future.
Whats in it for you: This is the place to hold your existing Database Infrastructure skills while having the chance to become exposed to fresh and divergent technologies (e.g. AWS/ Snowflake/ Terraforms/)
Responsibilities
- Database Design Architecture: Design scalable, high-performance database solutions using SQL Server, Oracle, or PostgreSQL.
- Define database schema structures, indexing strategies, and partitioning techniques for optimal performance.
- Develop data models to support application requirements and ensure data integrity.
- Establish standards for database design, security, and performance tuning.
- Database Development Integration: Work closely with development teams to implement database solutions that align with application requirements.
- Develop and maintain stored procedures, functions, triggers, and views for business logic.
- Ensure seamless integration between database systems and data pipelines.
- Performance Tuning Optimization: Analyze database performance metrics and implement indexing, caching, and partitioning strategies.
- Leverage tools like SQL Server Profiler, Oracle AWR,
and AWS Performance Insights to monitor and improve performance.
- Data Security Compliance: Implement encryption, access controls, and auditing measures to secure data assets.
- Ensure compliance with industry standards such as GDPR, HIPAA, or ISO standards.
- Collaborate with security teams to manage database vulnerabilities and risks.
- Backup Disaster Recovery: Develop comprehensive backup, recovery, and failover strategies for business continuity.
- Design high availability solutions using SQL Server Always On, Oracle Data Guard, or AWS Multi-AZ configurations.
- Collaboration Documentation: Work closely with stakeholders to gather business requirements and translate them into technical solutions.
- Maintain detailed documentation for database designs, configurations, and performance benchmarks.
What We're Looking For
- Expertise in database design, data modeling, and schema development.
- Solid experience with SQL Server, Oracle, and cloud database solutions like Amazon RDS or Azure SQL Database.
- Proficiency in database performance tuning, query optimization, and indexing strategies.
- Experience with data replication, partitioning, and sharding techniques.
- Proficiency in automation tools such as AWS CloudFormation, Terraform, or Ansible.
- Excellent problem-solving and communication skills.
- 12+ years of experience in database design, architecture, and administration.
- Proven experience in cloud database solutions and large-scale data management projects.
Preferred Certifications
- AWS Certified Database Specialty
- Microsoft Certified: Azure Solutions Architect Expert
- Oracle Certified Master (OCM)
- Certified Data Management Professional (CDMP)
📌 Lead Database Engineer (Bengaluru)
🏢 Su0026P Global Market Intelligence
📍 Bengaluru