The Sr. Database Developer will work as part of the Application Development team and other SQL Server Developers that are part of the DBA/Development team. The main responsibilities include: design and developing custom SQL Server Applications/Code (using T-SQL), creating and supporting robust ETL applications (using both T-SQL and SSIS), and root-cause analysis for various development related problems (bugs in code, performance, and locking/blocking).
The ideal candidate will have experience in database design and the capability of understanding and implementing business requirements from Business Analysts and other interested parties. Additionally, the understanding of other components of Microsoft’s BI stack (SSAS and SSRS) and IBM Cognos/Tableau/Power BI is a plus. The Database Developer must have a proven record of excellent results, be a great communicator, and a team player.
Major Duties and Responsibilities:
Perform all aspect of database development under the direction of the DBA manager including:
- Thorough code review of current and past development efforts.
- Code optimization and performance tuning.
- Manage the architecture, design, development, and implementation of database components; and ensure they meet established specifications on time and quality standards.
- Create detailed design documentation.
- Development of complex SQL Code (stored procedures, triggers, views and functions).
- Security assessment and compliance.
- Thorough understanding of indexing (Clustered/Non-Clustered).
- Modify/Create/maintain and optimize ETL processes using SSIS.
- Conduct research on emerging database and data warehouse technologies.
- Interact with project management group and stakeholders to ensure accurate and comprehensive understanding of data and reporting requirements.
- Liaise with network administrators, systems analysts, and software engineers to assist in resolving problems and provide issue escalation in a timely fashion.
- Provides issue escalation and resolution as well as timely execution of deadlines.
- Other duties as needed.
Required Qualifications:
- Bachelor’s degree in Information Systems/Technology, Computer Science, or a related field.
- 8+ years of IT software development industry experience.
- 4+ years’ experience working with databases preferably Microsoft SQL Server Databases 2012 / 2016.
- Working technical knowledge database design, administration and development (T-SQL).
- Working technical knowledge about SSIS packages.
- Understanding and general knowledge of Data Warehousing (Inmon & Kimball) and Business Intelligence (experience preferred).
- Experience working in Agile environment.
- Understanding of SSRS, SSAS, IBM Cognos or other Reporting platforms (experience with these platforms preferred).
- Understanding of database security and knowledge of applicable data privacy practices and laws.
- Understanding and experience in Database/Metadata analysis and design.
- Demonstrated ability and willingness to help with production support needs at times, in addition to development projects ("team player" mentality).
- Strong written and oral communication skills.
- Self-directed and proactive; thinks beyond the immediate problem.
- Flexibility, ability to change priorities quickly, capacity to handle multiple tasks and execute tasks in a high-pressure environment with keen attention to detail.
- Work directly with both internal and external resources to insure timely completion of assigned deliverables.
- Proven analytical and problem-solving abilities.
- Experience working both independently and, in a team-oriented, collaborative environment.
Desired Qualifications:
- Good understanding of Database Administration fundamentals and core concepts including:
- Backup, Recovery & Recovery Models
- Database Security (Users, Roles, Schemas, Orphaned Users)
- Database Storage Fundamentals (Pages, Extents, etc.)
- Working knowledge of SQL Server High Availability and Disaster Recovery.
- Understanding of Data Modeling (both physical and logical).
- Understanding of new Developer/DBA features for SQL Server 2012 and experience with using it even in the capacity of development or R&D.
- Understanding of SSRS, SSAS, IBM Cognos or other Reporting platforms.
- Experience in Healthcare IT or Support environment a plus.
About Us:
At the American College of Cardiology, we bring our hearts to work.
We are a 500-person organization dedicated and committed to our mission to transform cardiovascular care and improve heart health for the past 70 years. When you join our team, you become part of a passionate culture that envisions a world where innovation and knowledge optimize cardiovascular care and outcomes.
Every day, we are committed to supporting our more than 54,000 members and their patients around the globe and in doing so, ensure our staff have a positive environment of teamwork, collaboration, professionalism and excellence. To learn more about why ACC has been recognized as one of Modern Healthcare's Best Places to Work in Healthcare please visit our site at: www.acc.org/jobs.
ACC is proud to be an equal opportunity and affirmative action employer. We celebrate diversity and are committed to creating an inclusive environment for all candidates and employees. All employment is decided on the basis of qualifications, merit and business need. EOE/AA including Vets and Disabled.
ACC is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact Crystal Nott, Director, Talent Management at cnott@acc.org or (202)375-6423.