Job Title: Mid-Level Database Developer
Job Summary:
We are looking for a Mid-Level Database Developer to design, develop, and optimize database systems for high-performance applications. The ideal candidate should have strong SQL skills, experience with relational and NoSQL databases, query optimization expertise, and a solid understanding of data security and performance tuning. This role involves working closely with software developers, data analysts, and system administrators to ensure efficient data storage, retrieval, and management.
Key Responsibilities:
- Design, develop, and optimize database schemas, tables, and relationships
- Write, optimize, and maintain SQL queries, stored procedures, views, and triggers
- Implement data modeling techniques and ensure database normalization and indexing for performance
- Optimize database performance, query execution time, and resource utilization
- Develop and manage ETL (Extract, Transform, Load) processes for data migration and integration
- Collaborate with application developers to design and implement database-driven solutions
- Ensure database security through user access control, encryption, and role-based permissions
- Manage database backup, recovery, and replication strategies for data integrity
- Work with cloud-based databases (AWS RDS, Google Cloud SQL, Azure SQL) and on-premise solutions
- Implement data warehouse concepts and optimize storage for analytical queries
- Monitor and troubleshoot database performance, deadlocks, bottlenecks, and query execution plans
- Stay updated on emerging database technologies, cloud computing, and big data solutions
Skills and Knowledge Required:
- Proficiency in SQL and relational database systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Experience with NoSQL databases like MongoDB, Redis, Firebase, Cassandra (optional)
- Strong understanding of query optimization, indexing, partitioning, and execution plans
- Expertise in stored procedures, triggers, functions, and transaction management
- Hands-on experience with database administration, tuning, and resource allocation
- Knowledge of data security best practices (encryption, role-based access, GDPR compliance)
- Familiarity with ETL tools (Apache NiFi, Talend, Informatica) and data pipeline automation
- Experience with cloud-based databases (AWS RDS, Azure SQL, Google Cloud SQL, BigQuery)
- Working knowledge of version control tools (Git, GitHub, GitLab, Bitbucket)
- Experience with database monitoring and performance tools (New Relic, SolarWinds, SQL Profiler)
- Basic knowledge of big data technologies (Hadoop, Spark) is a plus
Educational Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field
- Certifications in SQL, Database Development, Cloud Databases, or Big Data Technologies are a plus
Experience:
- 3-5 years of hands-on experience in database development, optimization, and administration
- Experience in handling large-scale databases, high-transaction environments, and cloud-based systems
Key Focus Areas:
- Database Performance Optimization & Query Tuning
- Data Modeling, Indexing, and Partitioning Strategies
- Cloud-Based Database Management & Security
- ETL, Data Warehousing, and Pipeline Automation
- Cross-Functional Collaboration for Scalable Database Solutions
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, Cassandra
- 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: Git, GitHub, GitLab
- Database Monitoring Tools: SQL Profiler, SolarWinds, New Relic, Prometheus
Other Requirements:
- Strong problem-solving and analytical skills for database performance tuning
- Ability to mentor junior developers and lead database design discussions
- Passion for optimizing databases, handling large datasets, and ensuring security
- Strong communication and collaboration skills with cross-functional teams