Community

Home >

Jobs >

Job Opportunity : Lead Database Engineer : Night Shift

Haryana, India (Hybrid)

Job Opportunity : Lead Database Engineer : Night Shift

4 Weeks ago • All levels • DevOps • Administrative • Undisclosed

About the job

15 skills required for this role

Add these skills to join the top 1% applicants for this job

confluence

shell

jira

github

azure

aws

python

sql

powershell

terraform

mysql

postgresql

scalability

oracle

cost-optimization

Job Description

Lead Database Engineer responsible for database engineering and administration, including design, planning, configuration, monitoring, automation, and space management. This role involves managing a team of database engineers, leading the database engineer’s forum, and providing subject matter expertise. Responsibilities include database migration and modernization to cloud platforms (AWS/Azure/GCP), capacity planning, high availability and disaster recovery strategy, patch management, troubleshooting, automation and scripting, performance analysis, and documentation. The role requires expertise in SQL Server, Oracle, MySQL, and PostgreSQL, along with experience in cloud technologies and monitoring tools. The position includes 24X7 production support and working with sales teams on product rollouts.

Must have:

Database design & administration
Team management & leadership
Cloud migration expertise (AWS/Azure/GCP)
SQL Server, Oracle, MySQL, PostgreSQL
Automation & scripting (Python, PowerShell)
Monitoring & alerting (Datadog, Azure Monitor)
High Availability & Disaster Recovery
Performance analysis & reporting

Good to have:

Experience with Infrastructure as Code (Terraform, CloudFormation)
Knowledge of ITIL and ticketing systems (ServiceNow)
Experience with Jira and Confluence

Job Description Summary

The Database Administrator Perform database engineering and administration activities including design, planning, configuration, monitoring, automation, self- serviceability, alerting, and space management, database backup and recovery. Plan computerized databases, including base definition, structure, documentation, long- range requirements, operational guidelines, and protection with a capacity to lead and advise on migration and modernization, discover, and execute workload migrations to Cloud (AWS/Azure/GCP).

Job Description

Manages and guides a team of database engineers to ensure their deliverables meet program requirements.

Leads the database engineer’s forum and drives resolution of issues.

Manages multiple database systems by providing subject matter expertise when needed and directing the work of others.

Influences policy and procedure development to ensure alignment with IT strategy.

Leads others in the use of analytical models and develop breakthrough insights or innovative solutions.

Capitalizes on deep understanding of (current or potential) business processes, strategic objectives, and challenges to anticipate and meet customer needs.

Establish credibility and build impactful relationships with our customers to enable them to be cloud advocates.

Capture and share industry best practices amongst the community.

Networks with key decision makers, leveraging a deep understanding of their unique perspectives and priorities to create and expand relationships.

Demonstrates expert knowledge of and monitors the customer’s industry and competitive environment to create effective customer solutions.

Create, maintain, and use Standard Operating Procedures (SOP’s) for migration execution and ensure long term technical viability and optimization of production deployments and administration.

Formulate and monitor policies, procedures and standards relating to database management.

Provide design standards and guidance for projects and technical roadmaps.

Mentoring and Training: Provide guidance and support to Level 1 and Level 2 DBAs, sharing knowledge and expertise to foster their professional growth.

Engage, Consult and Deliver based on interactive customer communications in streamlining project deliverables and scope of work.

Capacity Planning: Forecast future database growth based on usage trends and plan for hardware and storage requirements accordingly to ensure scalability and optimal performance.

Plan, Create, Manage and Deploy Effective High Availability and Disaster Recovery strategy/Runbooks.

Patch Management and Upgrades: Plan and execute Database software upgrades, patches, and service packs.

Troubleshooting and Issue Resolution: Investigate and resolve complex database-related issues, including data corruption, performance problems, and connectivity challenges.

Automation and Scripting: Suggest, Develop, Analyse, provide solutions for automation initiatives and tools to streamline repetitive tasks, improve efficiency, and reduce the risk of human errors.

Monitoring and Alerting: Set up monitoring and alerting systems to proactively identify and address potential database issues before they become critical.

Performance Analysis and Reporting: Generate performance reports and analysis for stakeholders and management to provide insights into the database environment's health and performance.

Documentation: Maintain up-to-date documentation of database configurations, procedures, and troubleshooting steps

Ticket Handling: Work to resolve Incident, Changes and Service request under the agreed client SLA.

Problem Management: Responsible/Accountable for resolving problem tickets by creating detailed RCA reports.

Vendor and Third-Party Tool Management: Evaluate and manage third-party tools and solutions that assist in database management, monitoring, and performance tuning.

Participate in sales implementations vendor calls to provide advanced knowledge in the purchase of software, hardware or services that can be used to improve the performance of the database server.

Works with the product organization to assist in the roll out of new products.

Participate in 24X7 production support for Database Operations.

Executes large sized, complex database projects. Ensures projects are properly documented and delivered.

Hand’s on with using cloud tech tools such as AWS DMS, SMS, App Migration Service, Migration Hub, Azure Migrate, Data Migration Service, SQL Server DMA, Azure ASR, AWS DRS

Migration from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora, AWS RDS, Azure Database, Azure MI, GCP Cloud SQL.

Understanding Cloud basics and perform duties like security management, storage management, Backup Vaults, Key vaults, Server/DB Monitoring

Cost Optimization: Compute and workload analysis, License enhancements and features.

Skills List

Experience working in Automation with Python/AWS CLI/PowerShell/Shell

Working on Infrastructure as a code with Cloud Formation, Terraform, GitHub

Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets SQL Server (Always On, FCI, Loshipping, Replication) or Oracle(RAC, Data guard, Golden Gate) , MySQL & PostgreSQL( Master slave replication, InnoDB cluster Set)

Knowledge of deploying and managing RDBMS in cloud platforms such as Azure SQL Database or/and Amazon RDS or/and GCP Cloud SQL

Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server or/and Oracle or/and PostgreSQL or/and MySQL)

Understanding of Monitoring tools such as Datadog or/and Azure monitor or/and AWS CloudWatch alerting and performance analyzation.

Understanding and usage of ITIL based tickets tools like Service Now.

Understanding and usage of tools like Jira, Confluence etc.

undefinedundefinedundefined

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%