Agno Talents · TN, India
Skills: SQL, AWS
Job Title: Database Developer
Job Summary
We are looking for a skilled Database Developer with strong expertise in SQL development, database design, query optimization, and data management. The ideal candidate should have hands-on experience developing database objects, optimizing query performance, designing scalable database structures, and supporting data migration and integration activities.
Key Responsibilities
1. Database Design and Architecture
Design and develop database schemas, tables, indexes, and relationships. Apply database normalization techniques to minimize data redundancy. Design scalable and efficient database structures. Document database models and architecture.
2. SQL Development
Develop and maintain stored procedures, functions, triggers, and views. Write complex SQL queries using joins, subqueries, aggregations, and other advanced SQL features. Optimize SQL queries to improve performance and efficiency. Implement constraints and validation rules to maintain data integrity.
3. Database Performance Optimization
Identify and resolve database performance bottlenecks. Create and maintain indexes for efficient query execution. Analyze execution plans and perform query tuning. Monitor database resource utilization, including CPU, memory, and I/O.
4. Data Migration and ETL
Perform data migration between databases and systems. Develop and maintain ETL processes and data transformation workflows. Cleanse, transform, and validate data. Ensure data accuracy, consistency, and quality.
5. Database Maintenance and Support
Support database backup and recovery activities. Monitor database health, availability, and performance. Apply database patches and updates as required. Manage database capacity planning and access controls. Troubleshoot and resolve production database issues.
6. Security and Compliance
Implement database security measures, access controls, and encryption. Monitor and audit databa …truncated… , procedures, and functions. Validate data integrity and consi…
Sign in to see the original posting
Browse more developer jobs on RoleBurst