Senior SQL Database Administrator

Database Administrator

Location: New York NY (Hybrid)

Duration: 12 month with possible extension

Job Description:

• We are looking for a Senior SQL Database Administrator for a 12month contract opportunity that is hybrid in New York NY.
• The ideal candidate will provide services to build and maintain MS SQLServers SSIS SSAS with the latest version.

What Youll Do:

• SME (L3 or above only) DBA consultant with ten plus years of experience will provide enterprise services to build maintain MS SQLServers SSIS SSAS with latest version. Implement CIS security best practices and automate the build standard. Implement policy management features to leverage the product features to roll out changes seamlessly. Example: SQL 2019 or above.
• Install upgrade and patch both existing and new database environments and other supporting tools such as SCCM or Ansible based automation.
• Implement alerts through SCOM and OEM monitoring on new build servers environment to automate DBA proactive jobs and actively monitoring.
• Hygiene best practice implementation SDLC change control best practices. Consultant will participate 24X7 production database support (Rota based) as required.
• Consultant must provide technical documentation of the work including all scripts and commands applicable in a standard word format. Perform general troubleshooting on all databaserelated issues and documenting solution steps.
• Partnership with application development production support teams and Implement changes to the production environment CAB based change management guidelines and approval. NonProduction will be approved SNOW SR based. He/She will be working with various CAPEX or OPEX type of projects tasks and update the project managers on a daily basis.
• Candidate should have experience independently on complex projects and at the same time possessing excellent team skills to be able to collaborate with various infrastructure groups
• Understanding of current support processes definition of the tobe processes and gap analysis
• Partnering with ITRisk CISO organization for planning and implementing security initiatives performing vulnerability assessments patch management antivirus management. Having knowledge of Qualys Scan is preferred.
• Establishing process for maintaining sound backups for all database environments. Such as SQL Server Full Differential Log backups automation
• Proactively monitor the SQL production databases and ensure alerts are provided when they occur take corrective action to resolve these issues and alert the IT management team of the issue.
• Consultant will follow the SDLC policies and implement such policies and procedures to mitigate future risks.
• Review hardening and securing the current databases as per CIS standards. Provide guidance for securing databases which store sensitive and/or restricted data
• Implementing database security controls via CyberArk to prevent data loss/leakage or unauthorized access to databases. Manage/Enhance Database Engine Security Configuration.
• Identify root cause analysis (RCA) of performance issues and recommend the best possible solutions. Conduct RCAs for recurring production Database Administration related problems and automation is the Key.

What Youll Need Required:

• 10 years in banking and financial services with a focus on IT and operations project management knowledge of Core Banking products and payment architecture.
• Bachelors or Masters degree with computer science as a major concentration.
• Knowledge of Banking solutions and applications integrated with banking solutions such as BSA/AML ACH payments transaction processing loans booking cash management and Private wealth management
• Broad commercial and private banking experience
• Experience with ServiceNow and auto ticketing implementation for database monitoring alerts
• Windows PowerShell or Linux scripting experience
• Experience with Always on Availability Groups (AG) HADR environment and advance database features such as Transparent data encryption (TDE) Policy management Resource Governor and Extended events
• Experience with data platform tools such as Delphix to virtualize the database environment dynamic data masking and DCT implementation
• Experience with auditing data architecture data warehouse Azure Purview SQL Server and AWS Databricks or RedShift. performance tuning ETL SSIS tuning for faster loads on heavy volumes of data processing

Preferred:

• Experience with Cohesity backup appliance F5 Load balancer to route the sessions Backup encryption and AWS S3 storage gateway implementation to upload backups securely in AWS cloud
• Experience with third party vendor based financial applications and collaboration with fintech experience to modernize portfolio optimization and rationalization of the database estate
• Oracle 12c 19c or 21c database experience as secondary not mandatory
• Experience with EMR Glue Amazon Quick Sight and data mesh implementation in AWS cloud
• AWS cloud certification is vital to perform hybrid cloud public cloud and private data centers. Nice to have exposure with Artificial Intelligence and Machine Learning experience in data engineering platform.

Physical Demands:

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal state and local standards
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings etc.
• Ability to conduct repetitive tasks on a computer utilizing a mouse keyboard and monitor

10+ years in banking and financial services,ServiceNow and auto ticketing, Windows PowerShell or Linux scripting experience