Apply for this job now

Sql Development DBA

Location
New York
Job Type
Permanent
Posted
12 Feb 2021

  • Design, install, configure, and manage enterprise database systems both on premise and in the cloud
  • Work with application developers and business users to design, architect and build new database strategies/schemas, and perform database code reviews
  • Establish, document, and implement best practices and standards for Database Development
  • Establish, document, and implement standards for Data Protection and Retention
  • Optimize data access processes and troubleshoot performance and data availability issues for all systems
  • Support all production systems including database maintenance, monitoring backups, query performance and DB release management
  • Define and enforce database security policies
  • Establish reporting strategy and solutions for traditional and mobile use cases
  • Become knowledgeable on business applications and systems to gain SME status
  • Further enhance DB server monitoring (both homegrown tools and vendor supplied tools) to proactively identify bottlenecks, capture metrics, and report on SLAs/KPIs
  • Research and evaluate new database tools and technologies for data warehouse and big data use cases

:

  • 8 years of experience managing medium/large enterprise SQL Server database systems
  • Advanced level knowledge of SQL Server features, functionality, and performance optimization techniques
  • Deep experience building and enforcing standards around how data is modeled, managed, and protected as a critical firm asset
  • Strong experience with data modeling, T-SQL, and creating and tuning Stored Procedures, Functions, SSIS Packages, etc.
  • Strong experience with reporting strategies and solutions such as SSRS, PowerBI, and Tableau
  • Strong knowledge and experience with virtualized database environments, high availability, and disaster recovery solutions
  • Data Warehouse and large-scale data integration experience
  • Understanding of cloud database implementations in AWS and Azure

· Coding experience in Python, PowerShell or other scripting languages

  • Familiarity with JIRA, Confluence, and Git source control

Apply for this job now

Details

  • Job Reference: 230505153-2
  • Date Posted: 12 February 2021
  • Recruiter: JK Partners
  • Location: New York
  • Salary: On Application
  • Sector: I.T. & Communications
  • Job Type: Permanent