Senior SQL Database Administrator

Job Title: Senior SQL Database Administrator Job ID: 2023-12228 Job Location: Alpharetta, GA or Berkeley Heights, NJ Job Travel Location(s): # Positions: 1 Employment Type: W2 Candidate Constraints: Duration: Long Term # of Layers:0 Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers Key Technology: MS SQL, Replication, Performance tuning, Partitioning, High Availability, Disaster Recovery Job Responsibilities: Administer all aspects of SQL server installations. Support and resolve all the issues related to high availability group and replication from test to production environments. Monitor and optimize the performance of application databases to meet performance and service level agreements, including index analysis and optimization. Tune and Optimize queries and access plans. Support application developers and architects in a consulting role Work with the DevOps team to develop application store procedures and setup data scenarios in Dev environments to do performance testing of the application. Participate in allocated DBA tasks, e.g., SQL Service pack upgrades, installations, backup, and recovery, tuning, performance monitoring, day-to-day support. Analyze the high-volume tables in production and provide strategies of implementing table partitioning of these tables to production. Troubleshoot and resolve Production incidents and participate in bridge calls in coordination with application support team in meeting the SLAs. Support the Application build team in their analysis of performance of application, deployment failures and high availability group in development and test environments. Perform database deployments and post deployment monitoring. Participate in development of databases and SSIS packages to meet requirements of new initiatives. Provide advice and guidance on database technology for new business systems. Manage ongoing initiatives, including server and system upgrades and maintain currency. Possess a knowledge of security and compliance and be aware of security standards. Skills and Experience Required: Required Strong expertise in MS SQL (2019) along with hands on experience Experience with Replication, Performance tuning, Partitioning, High Availability, Disaster Recovery (backup/restore), Import/exports, building up DB from scratch, DB upgrades. Experience with server virtualization including Hyper-V and VMWare. Must understand the concepts of server virtualization. Experience in the Banking and/or Financial Services Industry Excellent skills in performance monitoring, tuning, space and size management. Experience on SSIS, SSRS and SSAS. Experience with database migrations. Broad experience in clustering high availability, fault tolerant systems, SAN Experience in defining Database Server Security, User Creation and Right Permission General experience of Windows Clustering and deployment process Experience with Splunk, ServiceNow, PowerShell, Database, and storage Encryption technologies (Data in motion and at rest) Excellent communication skills, written and verbal, to share your knowledge, teach what you know, and learn new ways of doing things from your team. Desired: Experience with database utilities and development procedures and familiarity with emerging technologies. Good knowledge of complex technologies, tools, methodologies, the enterprise architecture, and industry Bachelor’s degree in computer science, Information Technology, or Business or equivalent degree Minimum 10+ years of experience a DBA on SQL Database Support, design, and development Minimum 2+ years of experience in an Advisor Role #J-18808-Ljbffr