We are seeking a highly skilled and experienced Senior Database Developer/Designer to lead the design, development, optimization, and administration of our database systems. The ideal candidate will have deep expertise in SQL Server, strong experience in database performance tuning, and a solid understanding of data modeling and secure database practices. Experience with MySQL, Oracle, or NoSQL databases (e.g., MongoDB, Cosmos DB) is a strong plus.
Key Responsibilities
Design and implement scalable, secure, and high-performance relational database solutions.
Develop and optimize stored procedures, functions, views, and triggers using T-SQL.
Collaborate with software developers and DevOps teams to integrate databases into applications and deployment pipelines.
Analyze and tune slow-performing queries, indexes, and execution plans.
Perform logical and physical data modeling, normalization, and schema design.
Implement and maintain data backup, recovery, and disaster recovery strategies.
Monitor database health, availability, and capacity using built-in and third-party tools.
Ensure data integrity, security, and compliance with internal and external standards.
Document database structures, processes, and best practices.
Mentor junior developers and contribute to database architecture decisions.
Required Skills & Qualifications
Bachelor’s degree in Computer Science, Information Systems, or a related field.
5+ years of experience in database development and administration.
Expert-level proficiency in Microsoft SQL Server (2016 or later).
Strong command of T-SQL, query optimization, and indexing strategies.
Experience with database design, normalization, and data modeling tools (e.g., ER/Studio, dbForge).
Familiarity with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
Solid understanding of database security, role-based access control, and encryption.
Experience with source control (e.g., Git) and working in Agile/Scrum environments.
Preferred (Nice-to-Have)
Experience with MySQL, PostgreSQL, or Oracle databases.
Exposure to NoSQL technologies such as MongoDB, Cosmos DB, or Redis.
Familiarity with cloud-based database services (e.g., Azure SQL, AWS RDS).
Knowledge of CI/CD pipelines and database versioning tools (e.g., Flyway, Liquibase).
Experience with data warehousing, ETL pipelines, or BI tools.
Soft Skills
Excellent communication and documentation abilities
Ability to work independently and collaboratively across teams.
Detail-oriented with a focus on performance, reliability, and maintainability.
