Sr. Database Developer
2 viewsremotestar-teamHyderabadHybrid
5+ years
Posted 7 days ago
- AWS
- MySQL
- PostgreSQL
Must-Have Skills
- Strong hands-on experience in database development and administration, including AWS RDS, performance optimization, replication, high availability, backup, and recovery.
- Hands-on experience in database development and administration, including schema design, SQL development, query optimization, performance tuning, backup, recovery, and troubleshooting.
- Strong expertise in writing complex, efficient, and optimized SQL queries for relational databases.
- Strong experience developing and optimizing stored procedures, functions, triggers, views, and other database objects.
- Deep understanding of RDBMS fundamentals, database architecture, indexing, transactions, concurrency, data integrity, and query optimization.
- Strong expertise in schema design, data modeling, normalization, ER diagrams, and dimensional modeling.
- Experience in database performance tuning, troubleshooting, monitoring, and capacity planning.
- Experience with replication, backup, recovery, failover, and high-availability strategies.
- Hands-on experience developing interactive dashboards and reports, creating DAX-based metrics and KPIs, analyzing data, and translating business requirements into BI solutions.
- Demonstrated experience in technical leadership, mentoring, code reviews, and guiding development teams.
Responsibilities
- Lead the design, development, and implementation of database solutions using MySQL and PostgreSQL. Develop and optimize SQL queries, stored procedures, functions, triggers, views, indexes, and other database objects.
- Define and enforce database development standards, coding practices, naming conventions, and architectural patterns. Ensure solutions are scalable, maintainable, secure, and reliable.
- Design and review logical and physical data models, schemas, ER diagrams, normalized databases, and dimensional models such as star and snowflake schemas. Ensure data integrity, consistency, and quality.
- Administer, configure, monitor, and optimize MySQL on AWS RDS, including replication, high availability, backup, recovery, failover, capacity planning, and database scaling.
- Develop, administer, and optimize PostgreSQL databases, including schema design, indexing, query optimization, performance tuning, backup, recovery, monitoring, and troubleshooting.
- Identify and resolve database performance issues such as slow queries, poor execution plans, indexing problems, locking, deadlocks, transaction issues, and resource bottlenecks. Perform root cause analysis and implement permanent solutions.
- Implement database security and access controls and maintain backup, recovery, replication, high availability, and disaster recovery strategies. Support RPO/RTO requirements and participate in recovery and failover testing.