Job Description

Job Type: Contract

Contract length : 06 Months

Summary:

The Senior IT Database Administrator (Senior DBA) provides consultation related to database management and administration. The Senior DBA’s perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows. Senior DBA’s administer database systems to protect the confidentiality, integrity and availability of data. The Senior DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data. Senior DBA’s also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures. The Senior DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.

• Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.
• Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.
• Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.
• Develops and ensures compliance with all system, disaster recovery and security audit policies.
• Writes complex programming/scripts.
• Participate in disaster recovery design, testing and execution
• Monitor and evaluate database performance and adjust database configuration as appropriate
• Provide technical leadership to other DBAs
• Design process for database change management issues related to environment migration
• Make highly complex physical changes to current databases, often this requires working after hours
• Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
• Provide subject matter expertise to corporate projects and initiatives
• Work with users and IT partners to understand requirements for a physical database design
• Provide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle concepts
• Address customer concerns and issues related to database management
• Evaluate database performance and adjust configuration appropriately
• Provide production support for outages, restore/recovery events
• Optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
• Other duties as assigned

Required:

• 7 or more year’s professional experience as a Microsoft SQL Server Database Administrator.
• Bachelor’s degree in an IT related field or equivalent work experience.
• Experienced in installing, configuring and upgrading SQL Server 2014, 2016 and 2019
• Hands on experience in SQL Server 2019, maintaining in memory tables, column store indexes, setting up polybase and R Services.
• Setup and support Microsoft SQL Server with Reporting Services, Analysis Service, Integration Services, and Business Intelligence.
• Experience in deploying SQL Server in virtualized environment and good understanding of Operating system concepts of Windows and Linux.
• Working knowledge of DISA STIG implementation for SQL Server and JSM audit submissions.
• Good knowledge of capacity planning and architecture design for database server deployment.
• Proven experience in working in a mission critical environment with database size of 20 TB plus.
• In depth Knowledge of setting up Always on Availability groups (AAG) and other HA solutions.
• Perform routine maintenance on several database environments including application of updates, patches, and hotfixes
• Creating databases, migrating database objects from non-production to production environment.
• Designing and building data models, schemas, views, and tables to support application requirements
• Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.
• Extensive experience designing and executing backup and recovery concepts and procedures
• Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning and BI stack related issues.
• Experience in performance tuning and administration of SSAS cubes.
• Experience in using SCOM for SQL Server Availability and performance.
• Good understanding of licensing options and optimization.
• Experience in scripting languages (PowerShell) for automating DBA administrative tasks.
• Experience with automation tools such as Control-M.
• Experience in implementing SQL Server STIG implementation, testing, and other vulnerability remediation.
• In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
• Provide 24 x 7 Support to Critical production systems.
• Knowledge of Project Management Methodologies

Preferred:

• Microsoft SQL Server Database Administration Certification.
• Administration of MongoDB, Postgres.
• Health care industry related experience.
• Experience using Agile Methodology.
• Experience working with Hyper converged infrastructure (example Nutanix)
• Experience with Hadoop.

REQUIRED EXPERIENCE/EDUCATION:

• 7 or more year’s professional experience as a Microsoft SQL Server Database Administrator
• Bachelor’s degree in an IT related field or equivalent work experience
• Working knowledge of DISA STIG implementation for SQL Server and JSM audit submissions
• Migration experience & working knowledge of SQL Server 2019
• Hands on experience with troubleshooting & performance tuning within SQL Server
• Windows clustering experience A PLUS
• Cloud/Azure experience a PLUS
• Working knowledge of tera databases is A PLUS

How to Apply

Job Types: Temporary.

241 total views, 0 today

Apply for this Job