Information Technology


SQL DBA/Developer  Fort Washington, PA  
Job Description

Job ID#:

1785

Job Category:

Information Technology

Position Type:

Full-time/Perm


We are working with an innovative Financial Services technology company that has built a leading-edge financial data analytics software product.  The company was founded in 2010 and is consistently winning recognition for being one of the top places to work as well as several industry awards for their technology.  They have a unique, highly collaborative, development/engineering culture there and they place more of a value on innovation and R&D than all of their competitors.  They are currently looking to hire a Database Administrator who has expert knowledge in SQL Server databases and also has the ability to code and develop with T-SQL.  The company has offices in New York City as well as the suburbs of Philadelphia.  There is an option to work out of either office (post-COVID) but for now everyone is working remotely for at least the remainder of 2020, and then looking to move to a hybrid on-site/remote schedule.  There is also an opportunity for this position to just be 100% remote.  The only requirement is that you must be a resident of one of these states: NY, NJ, MD, PA, TX, SC, VA, and Washington DC. 

This DBA position encompasses a wide range of responsibilities including the installation, configuration, administration, and maintenance of SQL databases and server systems.  This is really a hybrid position where half of the time is spent performing traditional DBA duties supporting the production environment, but the other half of the time is spent analyzing and coding complex T-SQL code and recommending and implementing performance tuning techniques.   This is a unique opportunity to have ownership of both development and production SQL environments and take part in strategic decisions around the direction of the DB environment as the company continues to grow.  

Responsibilities:
  • Oversee all Database Operations including planning, configuration, trouble-shooting, monitoring, security configurations and migrations
  • Build & Manage SQL Server databases in multiple environments, from development to mission-critical production systems.
  • Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
  • Always look for opportunities to improve performance using database optimization techniques (both from database design perspective and T-SQL tuning).
  • Identifying opportunities to implement automation and standardize delivery of DBMS services to support faster and more flexible service delivery without impacting quality or performance.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
  • Apply data modeling techniques to ensure SQL implementations & integrations meets or exceeds performance requirements
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan, coordinate and manage data migrations and replication between systems.
  • Help development team members write efficient queries
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Working with SQL in public cloud spaces like AWS, Azure, etc
  • Be part of an On-Call Rotation

 
Job Requirements

 

Background:
  • 6+ years MS SQL Server Administration experience required (ideally some experience supporting VLDB environments (>5TB).
  • SQL DBA Production Support Expertise to include:
    • SQL Clustering - setting up cluster, supporting it, building it from scratch, troubleshoot, etc.
    • SQL Server 2016 and 2017 are a must --- 2019 is nice to have
    • Performance Tuning - ability to re-write entire queries if need be
    • AlwaysOn
    • Must have a solid understanding of SQL Server Internals
  • Deep knowledge of T-SQL query tuning and Performance Tuning and Optimization (PTO) techniques using native tools
  • Experience with backups, restores and recovery models
     
  • Demonstrated understanding of complex SQL, stored procedures, database functions, SSIS and ANSI and T-SQL queries and scripts.
  • Knowledge of High Availability (HA), Always On Availability Groups, MS SQL Clustering and Disaster Recovery (DR) options for SQL Server
  • Demonstrated knowledge of Data Security, SQL Server Database Encryption (TDE) and data protection best practices
  • Experience working with Windows server with a working knowledge of general Datacenter operations both physical and virtual
  • Experience with Automation - practiced at identifying what can be automated as well as how and when. 
  • Open source DBMS and noSQL experience is a plus (MongoDB, Aerospike, Snowflake, MySQL, Cassandra)
  • Experience with data processing flow-charting techniques.
  • Experience managing SQL Server databases in the cloud, Azure experience preferred
  • Project management experience.
  • Good understanding of the organization’s goals and objectives.
  • Knowledge of applicable data privacy practices and laws.
  • Good written and oral communication skills.
  • Strong technical documentation skills.
  • Good interpersonal skills.
  • Ability to conduct research into database issues, standards and products as required.
  • Experience working in an agile project methodology




 

Already have an account? Log in here