What are the responsibilities and job description for the SQL Server DBA position at Brains Workgroup, Inc.?
Our client, a major bank in New York City, is looking for Senior SQL Server DBA. New York City or Central NJ Location.
This is hybrid commute, 2 days per week in the office.
** Must be authorized to work for ANY employer in US - NO H1 Visa support for this role
Salary range 130-155K, plus around 10-15% bonus, plus great benefits package.
Will be responsible for maintaining the firm’s MS SQL Server systems ensuring resiliency, uptime, HA/DR, performance, capacity planning, overall monitoring and documentation.
This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, a focus on managing and resolving issues in alignment with MAS SLAs, establishing and maintaining communication with stakeholders to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established time frames.
Position Requirements:
Please email your resume or use this link to apply directly:
This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, a focus on managing and resolving issues in alignment with MAS SLAs, establishing and maintaining communication with stakeholders to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established time frames.
Position Requirements:
- Experience administering SQL Server 2012 to SQL 2019 at a L3 level.
- 7 years of relevant experience
- Experience with SQL Azure (IAAS, PAAS, SQL DB)
- Act as a senior operational/escalation DBA
- Resolve monitoring alerts related to disk space and CPU/memory resource contention, instance availability and similar basic monitoring metrics.
- Help manage replication and HA technologies, namely log shipping, transactional replication, SQL Server Availability Groups, database mirroring, and Oracle RAC.
- Manage HA/DR setups to meet or exceed application RTO/RPO targets and implement solutions for managing backup and recovery.
- Troubleshoot and resolve performance issues including but not limited to investigating infrastructure issues, query execution plans, query store, generate traces, execution plans, identify and resolve performance issues, address deadlocks/contention.
- Evaluate on premise SQL workloads for migration to Azure and recommend appropriate Azure services
- Install, configure, and maintain a SQL footprint in Azure, including SQL on Azure VM, Azure SQL Managed Instance, Azure SQL Database.
- Migrate on-premise SQL workloads to Azure.
- Automate routine database tasks and processes using tools like PowerShell and Azure Automation.
- Use available toolset (OpsRamp, SQLSentry, etc.) for database monitoring & tuning.
- Support change requests by deploying SQL scripts or other code fixes as relayed by the business.
- Support software developers to drive proper coding practices and assist in the development of complex SQL, tuning of DML and the creation of stored procedures/functions/triggers/etc.
- Engage in continuous sizing analysis to forecast growth and work with storage team to ensure adequate space on all servers.
- Maintain data integrity and security (manage roles and permissions of database users).
- Effectively coordinate and communicate with all stakeholders.
- Learn and exercise relevant business procedures, processes and understand data flow, criticality and dependencies.
- Participate in 24x7 on-call rotation to support database environment.
- Support ancillary systems in the database environment (Delphix, monitoring applications, etc.)
- Other general DBA administration tasks
https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16654390
Or email: igork@brainsworkgroup.com
Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers
Keywords:SQL DBA Azure IAAS PAAS RTO RPO Oracle Powershell automation OpsRamp security stored procedures Delphix
Or email: igork@brainsworkgroup.com
Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers
Keywords:SQL DBA Azure IAAS PAAS RTO RPO Oracle Powershell automation OpsRamp security stored procedures Delphix