SQL DBA /Hybrid role

Sql server, AWS, .NET, Amazon Web Services, Microsoft SQL Server DBA, Microsoft SQL Server
Contract W2, Contract Independent, Contract Corp-To-Corp
Depends on Experience

Job Description

Must have 10 years DBA exp 

The Senior Database Administrator will also take primary role in the definition of database administration best practices and database development standards across critical business application areas. To succeed at this function requires that the individual represents subject matter expertise in all aspects of MSSQL Server infrastructure including MSSQL Server installations , database performance tuning , backup and recovery, HADR solutions, compliance and security setup and provide excellent database support

Primary Responsibilities and Duties:

  • Provide specifications for provisioning new MSSQL Servers and manage their installation and configuration to provide optimum results
  • Plan database upgrades and patching to avoid operational risks by maintaining application support requirements.
  • Ensure database backup strategies are meeting Recovery Point and Recovery Time Objectives Track space usage trends and ensure adequate capacity for future growth of database environments.
  • Provide Subject matter expertise on database design and database performance issues. Research and recommend new database software in area of database security, database monitoring and database development.
  • Oversee production release management processes for database code promotions for various business applications.
  • Perform development and test data refreshes as per business needs.
  • Control and apply database access permissions, privileges and controls to maintain database security as per organizational standards.
  • Develop & document best practices for all aspects of MSSQL Server management, database development  & Database operation and Security Involve in architecting and implementing DR solutions with Always On, SQL log shipping, DB Mirroring, Replication.
  • Mentor DBAs and Application Developers, manage and facilitate interface throughout organization to provide database technical support, advice and problem resolution for database centric issues.
  • Provide Subject matter expertise on database design and database performance issues. Research and recommend new database software in area of database security, database monitoring and database development.
  • Collaborate between Infrastructure Teams and Application Development Teams for scalable , efficient databases applications.
  • Monitor MSSQL Servers for transaction latency, blocking and deadlock issues, and provide guidance in preventing/avoiding these issues to application development teams.
  • Work with external and internal auditors to improve security, and develop & implement database auditing process, participate in database compliance and security audits and publish needed reports to upper management

 

Minimum Education and/or Experience Requirements:

  • Bachelor’s degree plus at least ten years related experience
  • Experience as Database Administrator in SQL Server Environment
  • Experience supporting database sizes about 200GB to 2TB in size
  • Experience supporting multiple instances of SQL 2000-SQL 2014 in production environment with components including SSRS, SSIS, SSAS, Clusters.
  • Experience with Database Management and database monitoring tools such as DMVs, PerfMon, Profiler, Extended Events, third party tools such as Spotlight, Foglight , Performance Analyzer, Redgate SQL Monitor, Idera Diagnostic Manager, Idera SQLSafe , Litespeed
  • Experience designing and documenting processes and procedures, database migration plans, database upgrade plans as per business requirements.
  • Experience in designing, configuring and maintaining High Availability and DR Solutions.
  • Powershell, C# or .NET Scripting is a plus

Required Knowledge, Skills and Abilities:

  • Strong verbal and written communication skills.
  • Must be detailed-oriented, results-driven, highly energetic and motivated.
  • Able to communicate efficiently and effectively to technical and non technical audiences.
  •      Must be highly organized, detail oriented, extremely responsive and able to prioritize a large number of tasks.
  • Ability to provide guidance to team members to meet deadlines and objectives
  • Strong commitment towards SDLC/Change Management Principles
  • Knowledge of data quality, data management and data testing strategies and practices.
  • Experienced with SQL installation on standalone and cluster servers across multi-subnet environments
  • AWS/Microsoft Azure Services, Virtualization, Storage Area Networks, Windows Server Administration.

 

Dice Id : 10203811
Position Id : 6935427
Originally Posted : 1 year ago
Have a Job? Post it

Similar Positions

Postgre SQL DBA - Onsite
  • Pyramid Consulting, Inc.
  • New York, NY, USA
Oracle Midrange Infrastructure DBA
  • QED National
  • New York, NY, USA
Oracle DBA
  • Cynet Systems
  • East Hanover, NJ, USA
Sr. SQL Administrator
  • Hired by Matrix, Inc.
  • Parsippany-Troy Hills, NJ, USA
Postgre SQL DBA
  • Pyramid Consulting, Inc.
  • New York, NY, USA
Database Administrator (Red shift/AWS)
  • Techtriad Team - T3
  • New York, NY, USA
SQL Server DBA
  • Tech Valley Talent
  • New York, NY, USA
Database Management Administrator (DBA)
  • SYSCOM, Inc.
  • Baltimore, MD, USA
Sr. Mainframe DB2 Database Administrator
  • Matlen Silver
  • Berkeley Heights, NJ, USA