SQL Database Developer
SQL Database Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
SQL Database Developer
Washington DC Hybrid Onsite
Long term
Must have: ETL SSIS TSQL Power BI Microsoft Fabric.
The Senior Database Application Development Associate will work as part of the Application Development Department alongside other SQL Server Developers within the DBA/Development team. This role involves developing custom SQL Server applications and code (using TSQL) building and supporting robust ETL applications (using both TSQL and SSIS) and performing rootcause analysis for developmentrelated issues such as code bugs performance problems and locking/blocking concerns.
The ideal candidate should have a strong background in database design and the ability to interpret and implement business requirements provided by Business Analysts and other stakeholders. Experience with additional components of Microsofts BI stack (SSAS SSRS) and PowerBI is a plus. The Senior Database Application Development Associate must demonstrate a proven history of delivering excellent results possess strong communication skills and work effectively in a team environment.
Major Duties and Responsibilities:
Perform all aspect of database development under the direction of the DBA manager including:
- Conduct thorough code reviews of current and previous development efforts.
- Optimize and tune database code for performance enhancements.
- Design develop enhance and support database applications.
- Develop complex SQL code including stored procedures triggers views and functions.
- Apply a deep understanding of indexing (Clustered/NonClustered).
- Modify create maintain and optimize ETL processes using SSIS/Python.
- Develop data extraction and import programs using SSIS.
- Demonstrate proficiency in conducting research on emerging database and data warehouse technologies.
- Collaborate with stakeholders including IT scrum teams to ensure a comprehensive understanding of business requirements.
- Work closely with network administrators systems analysts and software engineers to troubleshoot and resolve issues escalating problems as needed.
- Perform additional duties as assigned.
Required Qualifications:
- Bachelors degree in Information Systems / Technology Computer Science or a related field.
- 7 years of experience working with databases preferably SQL Server.
- 7 years of experience in developing ETL processes including the use of SSIS packages in a Microsoft SQL Server database environment.
- Extensive experience working with MS SQL Server versionsand 2019.
- Proficiency in Python programming with essential experience in data manipulation and analysis. Familiarity with libraries such as NumPy Pandas pyodbc and SQLAlchemy is a plus.
- Technical expertise in relational and dimensional database design.
- Strong understanding of database security principles and data privacy practices/laws.
- Experience in database/metadata analysis and design.
- Excellent written and oral communication skills.
- Strong interpersonal skills with the ability to work in a teamoriented environment.
- Selfdirected proactive and capable of solving problems beyond immediate tasks.
- Flexibility to adapt to changing priorities and manage multiple tasks efficiently.
- Experience working with internal and external resources to ensure timely completion of deliverables.
- Proven ability to prioritize and execute tasks in highpressure environments with attention to detail.
- Strong analytical and problemsolving skills.
- Ability to work independently and collaboratively in a team environment.
- Familiarity with Microsoft Fabric technologies including Data Lake Data Warehousing and data governance.
Desired Qualifications:
- Proficiency in SQL development with a solid grasp of database design optimization and query performance tuning.
- Good understanding of core database fundamentals including:
- Backup and recovery processes.
- Security concepts such as users roles and schemas.
- Storage basics like pages extents and data files.
- Experience with SQL Server High Availability and Disaster Recovery solutions such as:
- SQL Server clustering and failover techniques.
- Database mirroring log shipping and transactional replication.
- Strong understanding of both physical and logical data modeling principles.
- Familiarity with SQL Server 2019 features with experience applying them in development or R&D settings.
- Experience with reporting platforms like SSRS SSAS PowerBI or similar tools.
- Experience with Microsoft Fabric is a plus
- Healthcare IT or support experience is a plus but not required.
- Database administration skills (backup recovery security) are a plus but not mandatory.
Employment Type
Full Time
