Cloud Database Engineer III/IV - (SQL server+ PostgreSQL/Mysql)
India - Gurgaon
Rackspace
As a cloud computing services pioneer, we deliver proven multicloud solutions across your apps, data, and security. Maximize the benefits of modern cloud.
10+ years
Key Responsibilities List· 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.· 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: Contribute to automation scripts 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 in 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 24X7 production support for Database Operations.· 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.· Knowledge ListProficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and TroubleshootingDatabase Migrations and Upgrades: 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)Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server and PostgreSQL or/ MySQL)SQL Server in the Cloud: Knowledge of deploying and managing SQL Server in cloud platforms such as Azure SQL Database and Amazon RDS.SQL Server Best Practices: 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.
Key Responsibilities List· 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.· 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: Contribute to automation scripts 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 in 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 24X7 production support for Database Operations.· 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.· Knowledge ListProficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and TroubleshootingDatabase Migrations and Upgrades: 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)Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server and PostgreSQL or/ MySQL)SQL Server in the Cloud: Knowledge of deploying and managing SQL Server in cloud platforms such as Azure SQL Database and Amazon RDS.SQL Server Best Practices: 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Job stats:
0
0
0
Category:
Engineering Jobs
Tags: Architecture ASR AWS Azure GCP MySQL PostgreSQL RDBMS Security SQL Testing
Region:
Asia/Pacific
Country:
India
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.
Senior AI Engineer jobsSr. Data Engineer jobsData Engineer II jobsBI Developer jobsPrincipal Data Engineer jobsStaff Data Scientist jobsStaff Machine Learning Engineer jobsData Manager jobsData Science Manager jobsData Science Intern jobsPrincipal Software Engineer jobsBusiness Data Analyst jobsJunior Data Analyst jobsData Specialist jobsResearch Scientist jobsData Analyst Intern jobsSoftware Engineer II jobsLead Data Analyst jobsDevOps Engineer jobsSr. Data Scientist jobsAI/ML Engineer jobsData Engineer III jobsJunior Data Engineer jobsStaff Software Engineer jobsData Engineering Manager jobs
Git jobsLinux jobsOpen Source jobsEconomics jobsAirflow jobsKafka jobsPhysics jobsComputer Vision jobsNoSQL jobsData Warehousing jobsMLOps jobsJavaScript jobsKPIs jobsGoogle Cloud jobsHadoop jobsPostgreSQL jobsRDBMS jobsScala jobsTerraform jobsScikit-learn jobsGitHub jobsData warehouse jobsBanking jobsR&D jobsStreaming jobs
Classification jobsPandas jobsOracle jobsDistributed Systems jobsBigQuery jobsPySpark jobsScrum jobsCX jobsReact jobsRAG jobsMicroservices jobsdbt jobsRobotics jobsLooker jobsJira jobsData Mining jobsIndustrial jobsRedshift jobsSAS jobsMySQL jobsJenkins jobsE-commerce jobsNumPy jobsUnstructured data jobsGPT jobs