Job Title: Mid-Level SQL Developer
Job Summary:
We are looking for a Mid-Level SQL Developer to design, develop, and optimize database solutions for high-performance applications. The ideal candidate should have strong expertise in SQL programming, query optimization, database design, and performance tuning. This role involves working closely with software developers, database administrators, and data analysts to ensure the efficient storage, retrieval, and management of structured data.
Key Responsibilities:
- Develop and optimize SQL queries, stored procedures, functions, triggers, and views
- Design and maintain scalable, high-performance database architectures
- Improve query execution time, indexing strategies, partitioning, and caching techniques
- Troubleshoot and resolve database performance bottlenecks, deadlocks, and slow queries
- Implement database security best practices, including role-based access control, data encryption, and audit logging
- Work with ETL processes, data pipelines, and data warehousing solutions
- Ensure database replication, backup, recovery, and disaster recovery strategies
- Collaborate with application developers to integrate databases with APIs, applications, and reporting systems
- Develop and maintain technical documentation for database schemas, processes, and best practices
- Stay updated on emerging database technologies, cloud-based solutions, and industry trends
Skills and Knowledge Required:
- Proficiency in SQL and relational databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Strong expertise in query optimization, execution plans, indexing strategies, and performance tuning
- Experience with stored procedures, triggers, transactions, and advanced query techniques
- Knowledge of database normalization, schema design, and data modeling
- Experience working with ETL tools, data migration strategies, and data transformation
- Familiarity with cloud-based databases (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake)
- Understanding of database security: authentication, authorization, role-based access control, encryption
- Knowledge of NoSQL databases (MongoDB, Redis, DynamoDB) is a plus
- Proficiency in database automation and scripting (Python, Bash, PowerShell)
- Experience with version control systems (Git, GitHub, GitLab)
Educational Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field
- Certifications in SQL Server, Oracle Database, AWS/Azure Cloud Databases, or Data Engineering are a plus
Experience:
- 3-5 years of experience in SQL development, database optimization, and performance tuning
- Experience in handling large-scale databases, high-transaction environments, and cloud-based solutions
Key Focus Areas:
- Advanced Query Optimization & Performance Tuning
- Data Security, Backup, and Recovery Strategies
- Cloud Database Management & High Availability
- ETL Processes & Data Warehousing
- Collaboration with Development & Data Analytics Teams
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Pipeline Tools: Apache NiFi, Talend, Informatica, Airflow
- Cloud Databases: AWS RDS, Google Cloud SQL, Azure SQL, Snowflake, BigQuery
- Version Control & Automation: Git, Terraform, Ansible, Docker
- Database Monitoring & Optimization Tools: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
Other Requirements:
- Strong analytical and problem-solving skills for database performance tuning
- Ability to mentor junior developers and participate in database architecture discussions
- Passion for scalable, secure, and efficient database management
- Strong communication skills to collaborate with cross-functional teams