ACT Consulting has an immediate need for Database Analyst with our direct client, a large health insurance company.

Please take a moment to review the job description. If this is something you are interested in, please send a copy of your resume to vishal@act-info.com or contact us at 803-760-7676 for additional details.

ACT Consulting is a U.S. owned and operated staffing company providing our clients with candidates on a national basis for contract, contract to hire, and direct hire engagements. Our clients are comprised mostly of Fortune 1000 companies, primarily in the areas of Information Technology, Engineering, Professional, Accounting and Finance.

Job Position: 2763 - Database Analyst
Location: Columbia, SC(Partial Onsite)
Duration: 12 Months on W2(No C2C)
Skills: DB2, IMS

Job Details:

• Partial Onsite
• C2 clearance required.
• Mainly IMS Database admin experience(Backbone of applications).
• Application side database admin.
• Mainframe, Z/os and IMS skills along with DB2 experience a plus.
• Utility Jobs, handle calls, monitoring IMS, partitioning, clone health plans, managing new programs etc.
• Will be slowly transitioning to DB2 and working on some DB2 applications.
• Experience 4 or 5 years as database admin.
• Interview: 1 or 2 rounds

Duties:

• Analyze and develop complex logical and physical database designs, data models and relational data definitions in support of corporate and client information systems requirements.
• Ensure that department standards for data are adhered to in constructing data management programs and tools. Perform regular monitoring, maintenance, and housekeeping for performance, capacity, and troubleshooting of assigned databases.
• Mentor less experienced personnel.
• 20% Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements. Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc) and administer existing architectures supported for performance and maintenance related issues.
• 20% Analyze and recommend best practice steps to prevent potential database issues, such as performance degradation or potential loss of service as well as recommend actions to fix issues when database problems do occur (outages or potential errors). Recommend methods to recover or improve databases to include analysis/review of vendor products.
• 15% Provide input into complex decisions as they relate to data architecture, infrastructure and/or administration. Consult with information systems areas on database issues and proposed changes. Recommend tuning to databases and queries when they are not performing to customer requirements.
• 15% Analyze and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements. Analyze and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.
• 15% Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities. Ensure recoverability of databases by creating, scheduling and monitoring database backups for dependent systems.
• 15% Support management on enterprise wide and departmental goals and objectives. Provide education and information on security policies, practices, and awareness programs. May provide estimation on work efforts and recommendations on training plans for less experience staff.

Skills:

• Knowledgeable in most aspects of constructing data marts, data architectures and operational data stores.
• Good business analysis, data acquisition, and access analysis and design skills.
• Able to provide input into complex decisions as they relate to data architecture.
• Able to relate knowledge of security issues for data management to less experienced personnel.

Required Education:

• Bachelor's degree in Computer Science, Information Technology or other job related degree. or 4 years of job related work experience or 2 years of job related experience plus an associate's degree in Computer Science, Information Technology or other job related degree.

Required Work Experience:

• 8 years of IT experience including varied database administration experience.