Connecting...

Database Development Specialist

Location: New York, USA Salary: US$80000 - US$115000 per annum + competitive
Sector: IT, Banking IT, Development, Security, Network and Cloud Type: Permanent

One of the largest payment system companies in the world is seeking to add a new Database Development Specialist to their team. You will work on architecture and design of a multi-terabyte SQL environment. Your role will have a large emphasis upon security, high availability, optimization, performance, tuning, and automation.

The Role:

  • Designing, developing, and maintaining large scale SQL Server Database structures
  • Designing, developing, and maintaining T-SQL code
  • Designing, developing, and maintaining Business Intelligence packages
  • SSIS Project Deployment Preference
  • Designing, developing, and maintaining SQL Reporting
  • SSRS Preference
  • Designing, developing, and maintaining Production trouble-shooting scripts for other internal groups
  • Designing, developing, and maintaining automation and deployment tools for the Operational DBAs
  • Powershell Preference
  • Creation and maintenance of Database servers within Development Environment
  • Work with other internal groups, 3rd party groups, and external customers to design needed solutions
  • Provide support to QC (Quality Control) and Operational DBAs on releases of code

Qualifications:

  • Bachelor's degree in Computer Science /Information Technology or equivalent experience
  • 8+ years of experience with Microsoft SQL
  • 4+ years of experience working with an enterprise database environment
  • Experience with MS SQL Server 2008 R2, 2012 R2 or newer
  • Excellent organizational and communication skills
  • Experience with Microsoft Visual Basic and/or Microsoft C#/.NET with preference being within ETL packages
  • Worked previously with SSIS, SSRS, and T-SQL
  • Experience in database architecture design with preference in multi-terabyte SQL databases of 8 TB or larger.
  • Worked with T-SQL, coding against billion row tables
  • Experience with ODS and data warehousing
  • Experience with TDE (Transparent Data Encryption)
  • Experience with fail-over and High Availability (HA) Groups
  • Knowledge of SQL Security - Physical, logical, encryption, authentication, roles, auditing, & logging

Good to have:

  • Certifications: MCDBA, MCSE, MCSA
  • Worked with TFS code control
  • Experience with table variables, temp tables and CTE's
  • Experience with SQL xml and vbscript
  • Experience with SSAS and cubes
  • Knowledge of data visualization tools; preferably Tableau
  • Experience with LDAP and Active Directory
  • Experience with DB2 Advanced Enterprise Edition 10.1 (or later) Database Administration in a High Availability environment

Sthree US is acting as an Employment Agency in relation to this vacancy.