Salary: $130k to $140k
Hybrid Position
We are seeking an experienced and detail-oriented SQL Server Database Developer/Administrator to join our dynamic team. This hybrid role combines both database development and administration responsibilities, requiring expertise in SQL development, database design, performance tuning, and data management within SQL Server environments. You will play a critical role in ensuring the scalability, optimization, and smooth operation of our database systems. The ideal candidate will be responsible for designing, developing, and managing SQL databases, writing complex queries, performing performance tuning, and supporting ongoing data processes.
Key Responsibilities:
Database Design & Development:
- Design, develop, and maintain relational database structures, including tables, views, and stored procedures, within SQL Server.
- Implement best practices for database schema design, normalization, and indexing strategies to ensure optimal performance and scalability.
- Develop complex SQL queries, functions, and triggers to support business processes and applications.
Performance Tuning & Optimization:
- Perform regular database performance tuning and optimization by identifying bottlenecks, optimizing queries, and enhancing indexing strategies.
- Analyze execution plans and monitor database performance metrics to ensure high availability and minimal downtime.
- Troubleshoot and resolve performance issues to maintain optimal database efficiency.
Data Migration & Integration:
- Design and implement data migration strategies for seamless integration between systems and ensure data integrity.
- Collaborate with ETL (Extract, Transform, Load) developers to optimize data pipelines and streamline data processing workflows.
Backup, Recovery & Security:
- Implement, monitor, and maintain database backup and recovery plans, ensuring minimal downtime and data integrity.
- Follow best practices for database security, including user permission management, encryption, and adherence to security protocols.
Collaboration & Support:
- Work closely with application developers, business analysts, and stakeholders to understand database requirements and deliver optimal solutions.
- Provide support for troubleshooting issues during development, testing, and production environments, ensuring seamless operation of data processes.
Documentation & Reporting:
- Document database design, development processes, and troubleshooting procedures for future reference and compliance.
- Provide regular reports on database health, performance metrics, and optimization efforts to stakeholders.
Requirements:
Education & Experience:
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience.
- Proven experience as a SQL Server Database Developer/Administrator, or similar role in a professional environment.
Technical Skills:
- Strong proficiency in SQL Server (2012 or later), including writing complex T-SQL queries, stored procedures, functions, and triggers.
- Extensive experience with SQL Server Management Studio (SSMS) and other database development tools.
- Solid understanding of database normalization, indexing, query optimization, and performance tuning techniques.
- Familiarity with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is a plus.
- Experience in implementing and maintaining database security protocols, including managing user permissions and applying encryption standards.
Performance Tuning & Troubleshooting:
- Strong analytical and problem-solving skills with a focus on database performance, query optimization, and execution plan analysis.
- Experience in identifying and resolving database bottlenecks to ensure high availability.
Backup & Recovery:
- Experience implementing and maintaining robust database backup, recovery, and high-availability solutions, including disaster recovery strategies.
Additional Skills:
- Strong communication skills, with the ability to work collaboratively across functional teams.
- Detail-oriented with a focus on data integrity, accuracy, and system performance.
- Ability to manage multiple tasks and deadlines in a fast-paced, dynamic environment.