Cloud Database Engineer III/IV

Summary

Join our team as a Database Administrator with 10+ years of experience. You will be responsible for creating and maintaining Standard Operating Procedures (SOPs), engaging with customers, and planning for database growth. Key duties include managing high availability and disaster recovery, performing database migrations, troubleshooting issues, and automating tasks. You will also be responsible for monitoring, performance analysis, and documentation. Experience with cloud technologies (AWS, Azure, GCP) and various RDBMS platforms (SQL Server, MySQL, PostgreSQL) is essential. This role requires strong problem-solving and communication skills.

Requirements

• Proficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and Troubleshooting
• Experience in planning and executing database migrations and upgrades, including version compatibility, testing, and minimizing downtime
• Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets SQL Server (Always On, FCI, Loshipping, Replication) MySQL or PostgreSQL (Master slave replication, InnoDB cluster Set)
• Experience with Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server and PostgreSQL or/ MySQL)
• Knowledge of deploying and managing SQL Server in cloud platforms such as Azure SQL Database and Amazon RDS
• Familiarity with industry best practices for SQL Server administration, including configuration settings, maintenance tasks, and disaster recovery strategies
• Ability to communicate technical info and ideas so others will understand
• Ability to apply varying leadership skills and traits that create solutions and results to unexpected situations
• 10+ years of experience

Responsibilities

• 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
• Engage, Consult and Deliver based on interactive customer communications in streamlining project deliverables and scope of work
• 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
• Plan and execute Database software upgrades, patches, and service packs
• Investigate and resolve complex database-related issues, including data corruption, performance problems, and connectivity challenges
• Contribute to automation scripts and tools to streamline repetitive tasks, improve efficiency, and reduce the risk of human errors
• Set up monitoring and alerting systems to proactively identify and address potential database issues before they become critical
• Generate performance reports and analysis for stakeholders and management to provide insights into the database environment's health and performance
• Maintain up-to-date documentation of database configurations, procedures, and troubleshooting steps
• Work to resolve Incident, Changes and Service request under the agreed client SLA
• Resolve problem tickets by creating detailed RCA reports
• Evaluate and manage third-party tools and solutions that assist in database management, monitoring, and performance tuning
• Participate in 24X7 production support for Database Operations
• Use 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
• Migrate from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora, AWS RDS, Azure Database, Azure MI, GCP Cloud SQL
• Perform duties like security management, storage management, Backup Vaults, Key vaults, Server/DB Monitoring
• Compute and workload analysis, License enhancements and features