SQL Database Administrator

***We are unable to sponsor as this is a permanent full-time role***

A prestigious financial firm is on the search for a Database Administrator.  This role is revolved around SQL database administration and development, tuning SSIS packages, T-SQL queries, and SQL execution plans. 

Responsibilities:

• Optimize stored procedures, functions and ad-hoc SQL
• Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems
• Implement, create reports and provide general support for SQL Server Reporting services
• Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation
• Review database objects and create and maintain change controls
• Monitor and maintain database security
• Migrate databases between servers and various platforms
• Analyze and resolve SQL Server faults
• Document data flows, application specifications from a DB perspective and system procedures
• Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
• Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
• Investigate and resolve reported application issues, escalating issues as necessary to the application owners
• Provide 24x7 on-call support on a rotating basis

Qualifications: 

• Bachelor’s degree in Computer Science or a related field or related experience
• A minimum of 5 years of experience with SQL
• Expert with SQL Server performance management and tuning, including identifying solutions that optimize SQL execution plans
• Tuning SSIS packages
• T-SQL
• SQL Server Administration experience including:
  • Triggers
  • SSIS
  • Stored Procedure Code Development and Standardization
  • Data Integration and Migration
  • Management Studio
  • SQL XML
  • Database Auditing and Controls
• Strong knowledge of Windows OS
• Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective