Etek It Services - New York, NY

posted about 2 months ago

Full-time - Mid Level
New York, NY
Professional, Scientific, and Technical Services

About the position

The Sr SQL Server Functional/Application DBA position is a critical role within a Global DBA unit, focusing on advanced database administration tasks and support for large-scale enterprise applications. This position requires a seasoned professional with extensive experience in SQL Server, particularly versions 2014 to 2019. The successful candidate will be responsible for performing 3rd Level support, which is the highest level of support, ensuring that database systems are running optimally and efficiently. The role involves working with substantial data warehouse sizes of 30TB or more, which necessitates a deep understanding of database management and performance optimization techniques. In this role, the DBA will conduct general database administration tasks, including database implementation, code deployments, backups, and user account management. The candidate must have a minimum of 10 years of experience in database administration, with at least 7 years specifically as a SQL Server DBA. The position also requires experience in functional and application DBA roles, with a strong emphasis on administering advanced database features such as clustering, encryption, logical/physical standby, ETL, and replication. Performance optimization of SQL code and server databases is a key responsibility, as is the creation and debugging of SSIS packages. The DBA will work closely with large-scale enterprise applications across multiple data centers, ensuring that all database systems are integrated and functioning seamlessly. This position is hybrid, based in NYC, and is offered as a 12+ month contract, making it an excellent opportunity for experienced professionals looking to contribute to a dynamic team in a fast-paced environment.

Responsibilities

  • Perform 3rd Level support for SQL Server databases.
  • Conduct general database administration tasks including implementation, code deployments, and backups.
  • Manage user accounts and permissions for database access.
  • Optimize performance of SQL code and server databases.
  • Administer advanced database features such as clustering, encryption, and replication.
  • Create and debug SSIS packages for data integration.
  • Work with large-scale enterprise applications across multiple data centers.
  • Ensure database systems are running optimally and efficiently.

Requirements

  • 10+ years of experience in database administration.
  • 4+ years of recent banking experience since 2018.
  • Recent experience performing 3rd Level support.
  • Experience working with DB/Data warehouse sizes of 30TB or more.
  • Minimum of 10+ years conducting general database administration tasks.
  • Minimum of 7+ years experience as a SQL Server DBA.
  • Experience as a Functional & Application DBA.
  • At least 5 years administering advanced database platform features.
  • 5+ years experience in a SQL DBA role with multiple databases and SQL development issues.
  • Proficient in MS SQL Server 2014 - 2019.
  • SSIS Package creation and debugging skills.
  • Stored procedure development and tuning skills.
  • Exposure to data replication.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service