What are the responsibilities and job description for the Senior Database Administrator (SQL Server & DB2) NYCG007 position at Ariel Partners?
We are seeking an experienced and highly technical Senior Database Administrator (DBA) with 8 years of experience in SQL Server (2014/2016/2019), SSIS, DB2, and both OLTP and OLAP data modeling using ERWIN. The Senior DBA will play a leading role in managing the enterprise data infrastructure, focusing on data modeling, performance optimization, high availability, and disaster recovery.
The ideal candidate will have expertise in configuring and maintaining SQL Server in virtualized and clustered environments, with hands-on experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
RESPONSIBILITIES:
- Serve as a key member of the database team responsible for end-to-end database administration, planning, and performance management.
- Lead data modeling efforts for OLTP and OLAP systems using ERWIN to ensure scalable and efficient data architecture.
- Install, configure, and maintain SQL Server databases in both virtual and clustered environments.
- Administer DB2 databases, ensuring integration and synchronization with SQL Server systems.
- Develop and manage SSIS packages for ETL workflows supporting data integration and transformation.
- Monitor and maintain database performance, availability, and reliability, including capacity planning and scaling strategies.
- Perform and troubleshoot SQL Server backups, restore strategies, and replication processes.
- Conduct advanced SQL Server performance tuning, indexing, and query optimization.
- Implement and support SQL Server Analysis Services (SSAS) for analytical processing and SSRS for enterprise reporting.
- Ensure database security, compliance, and disaster recovery protocols are properly implemented and tested.
- Collaborate with application developers, system engineers, and business analysts to support project needs and resolve database issues.
- Create and maintain documentation related to system configurations, architecture, processes, and best practices.
MANDATORY SKILLS/EXPERIENCE
Note: Candidates who do not have the mandatory skills will not be considered
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 8 years of experience in database administration and enterprise-level database management.
- Expert in:
- SQL Server 2014/2016/2019 administration
- SSIS (ETL development)
- DB2 database environments
- OLTP and OLAP data modeling using ERWIN
- SSAS and SSRS for analytics and reporting
- Strong hands-on experience with:
- SQL Server clustering and virtualization
- Backup/restore strategies, log shipping, replication, and disaster recovery planning
- Performance tuning, query optimization, and indexing strategies
- Solid understanding of data governance, security best practices, and audit compliance.
- Excellent troubleshooting, analytical, and problem-solving skills.
- Strong documentation and communication skills.
PREFERRED EXPERIENCE:
- Microsoft Certified: Azure Database Administrator Associate or SQL Server Certification
- Experience with cloud-based databases and hybrid database architecture
- Familiarity with DevOps pipelines and automation tools (e.g., Azure DevOps, Git) Experience working in large-scale public sector or education environments, especially NYC DOE
If you are interested in getting more information about this opportunity, please contact Irina Rozenberg Recruiting@arielpartners.com at your earliest convenience.
At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges we’re on their short list. We’re looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.
Salary : $80 - $85
