Sign in

IT - Database Analyst - Senior

Company:
Pozent
Location:
Golden Valley, Minnesota, United States
Posted:
November 05, 2018

Description:

Work to be performed either in Minnesota, Georgia, or remotely.

TRICARE- NACAs a requirement of Health Care Company s contract with the Department of Defense, this position requires U.S. citizenship and a credit check to be run as part of the standard background package.

The Data Activity Monitoring Team (DAM) is responsible for deploying Guardium for 80,000Databases and implement advanced blocking and protection and is looking for Database Administrators to support infrastructure support for the following database types (1 each): Oracle, SQL Server, MYSQL, Sybase, DB2, Mongo.

Database subject matter experts assigned specifically to the specific applications for 24/7 infrastructure support (P1/P2) and streamlining installation and trouble shooting in support of Guardium installations for the specific types of databases to be monitored.

Provide primary support for Health Care Company databases in support of DAM.

Develop PowerShell scripts and automation to support our enterprise automation strategies and goals

Plan and design new implementations, including database definition, structure, documentation and long-range requirements

Demonstrate the knowledge and ability to perform in all of the basic database management skills of database administration, web connectivity, physical structure, overall architecture, and database analysis.

Provide standardization and consistency across environments

Apply database management consulting skills and gather user requirements

Provide on-call support, answer severity calls, and provide problem resolution

Design, implement, and monitor database functionality to ensure stable environments

Uphold enterprise policy guidelines and recommend new and improved guidelines

Qualifications:

At least 5 years experience working with SQL Server 2008, 2012, or 2014 (strong preference in a production support role), or Oracle, MYSQL, Sybase, DB2, and Mongo.

Experience with SQL DBMS monitoring and tuning

At least 3 years experience writing PowerShell support scripts or other third party tools, commandlets, and functions for automated management tasks.

Experience with SQL Server Always-On Availability groups

Four-year degree in Business Administration, Computer Science, Mathematics, or equivalent experience

Effective verbal and written communication skills in both business and technical areas

Strong organizational skills to handle changing priorities, tight schedules, and correction of critical systems outside of normal working hours

Proven ability to maintain leading edge skills in a rapidly changing and fast-paced information systems environment

Desired Qualifications:

Background in corporate job schedulers (i.e. IBM TWS)

Experience with third-party backup tools

Experience with third-party monitoring tools (i.e. Foglight)

Experience working with remote teams

Experienced database administrator background with development (programming/scripting) skills looking to grow into security role with a primary objective of implementing IBM Guardium.

Demonstrated ability to design, implement and maintain all functions of database systems, including access, methods and time,device allocations, validation checks, organization, security, documentation, and statistical methodology.

Monitors overall standards and procedures, assists in integrating various systems. Consults with users, determine requirements.

Familiarity with PCI, SOX, SSAE16, and HIPAA/HITECH requirements. Support the maintenance of relevant controls for a heterogeneous database environment consisting of Oracle, Teradata, Hadoop, Microsoft SQL Server, Mongo, and Mainframe DB2 to ensure compliance with the same.

Develop new approaches to ensure compliance with standards and identification of security anomalies through automation and implementation of an enterprise database monitoring capability.

Core work hours are 9am-5pm with potential on-call after hours for high priority outages or security events.

Interview process can be a combination of face to face, phone, or Skype.