18 Aug
|
Improving
|
India
Key responsibilities:
Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL.
• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques.
• Conduct regular database health checks and performance reviews to ensure optimal operation.
• Collaborate with development and operations teams to support application data requirements.
• Write and optimize complex SQL scripts to meet business and operational needs.
• Support the DBA Team Lead with day-to-day database operations and incident resolution.
• Assist in monitoring database availability, integrity, and backups.
• Document database structures, procedures, and changes in a clear and organized manner.
• Implement best practices for data storage, retrieval, and processing efficiency.
• Contribute to the continuous improvement of database standards and internal processes.
• Identify and effectively prioritize situations requiring urgent attention.
• Stay current with system information, database technologies, changes, and updates.
• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments.
• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code).
• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership.
• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data).
• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting.
• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort.
• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms).
• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA.
• Articulated English skills, both written and spoken.
• Proficiency in T-SQL and/or standard SQL.
• Ability to multi-task and adjust priorities quickly in a rapid-paced environment.
• Ability to research and implement solutions using available technical resources.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to clearly communicate technical concepts to non-technical stakeholders.
• Advanced knowledge of database performance tuning and query optimization.
• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS RDS, or equivalent.
• Experience with database deployment automation and CI/CD pipelines.
• Understanding of high availability, disaster recovery, and data protection strategies.
• Working knowledge of database monitoring and performance management tools.
• Basic scripting skills (PowerShell, Python, or Bash) for automation.
• Awareness of data security and compliance considerations in regulated environments.
Skills:- DBA, SQL, Microsoft SQL Server, Bash, Powershell, MariaDB, DevOps, CI/CD, AWS RDS, Microsoft SQL Server DBA and Python
📌 Database Administrator (India)
🏢 Improving
📍 India