DBA Specialist (SQL/Oracle/DB2/Teradata)

At HCSC, we consider our employees the cornerstone of our business and the foundation to our success. We enable employees to craft their career with curated development plans that set their learning path to a rewarding and fulfilling career.
Come join us and be part of a purpose driven company who is invested in your future!
Job Summary
This position is responsible for maintaining/supporting application teams with database needs. Including but not limited to database administration, developing, integrating, testing, and maintaining existing and new databases; knowing one or more database environments; familiar with multiple delivery models and methodologies.
Required Job Qualifications:

• Bachelor Degree and 8 years Information Technology experience OR Technical Certification and/or College Courses and 10 year Information Technology experience OR 12 years Information Technology experience.
• Possess ability to sit and perform computer entry for entire work shift, as required.
• Possess ability to manage workload, manage multiple priorities, and manage conflicts with customers/employees/managers, as applicable.

SQL Server:

• SQL Server Developer
• SQL Server T-SQL (Table Design/Creation, Stored Procedures, Triggers etc.)
• SQL Server Integration Services (SSIS) packages
• Debugging SSIS package issues (Both package/project deployment model)
• SQL Server Reporting Services (SSRS)
• SQL Server Analytical Services (SSAS)
• SQL Server Upgrade Knowledge
• SQL Authentication Vs Windows Authentication
• SQL Server Directory

DB2 Distributed:

• DB2LUW Databases V11.1 and V11.5 environments
• Scripting knowledge (KSH, Perl, or PowerShell)
• AIX to LINUX Migrations
• Database Design Discussions (Business/Technical) at All Levels
• Translation of Business/Logical Requirements into Design for Delivery
• Performance Tuning, Enhancement, Modifications, Recovery and Backups

Oracle:

• Oracle Certified DB Professional (OCP)
• ORACLE in a Production 19c RAC (ASM) Environment (19c)
• Oracle ORMB
• Troubleshooting Oracle Performance Issues
• Dyntrace and Oracle OEM
• Oracle Standby Datagaurd.
• Upgrade/Database Patching for Stand-alone/Multiple node RAC clusters
• Implementation of Backup/Recovery of the Oracle Database
• Security Implementation/Enhancements of Oracle Databases
• Performs Database Performance
• Review/Design Code Frequently for Company Standards
• Technical Support to Application Development Team

Teradata:

• Teradata database knowledge: Teradata basic database fundamental, Teradata Database Administration, Teradata System Administration (a plus)
• Teradata NT and MVS Utilities (BTEQ, FastExport, FastLoad, MultiLoad, Tpump, TPT)
• Teradata Query Tools: Teradata Studio, ODBC, JDBC.
• Teradata System Tools: ViewPoint, PDCR, DBQL, TASM, TaraGui, TDBARS, DSA/NetBackup;
• Operating System Tools: Window, Unix, IBM Mainframe (OS/MVS)

zOS:

• DB2 z/OS Databases v12 and v13
• DB2 Utilities (COPY, RECOVER, REORG, LOAD, UNLOAD, CHECK, RUNSTATS)
• Scripting knowledge (JCL, REXX, Native Stored Procedures)
• Database tools (Data Studio, Omegamon, CA tool suite)
• Database Design Discussions (Business/Technical) at All Levels
• Translation of Business/Logical Requirements into Design for Delivery
• Performance Tuning, Enhancement, Modifications, Recovery and Backups

Preferred Job Qualifications:

• Bachelor Degree in Computer Science or Information Technology.

Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!
HCSC Employment Statement:
HCSC is committed to diversity in the workplace and to providing equal opportunity and affirmative action to employees and applicants. We are an Equal Opportunity Employment / Affirmative Action employer dedicated to workforce diversity and a drug-free and smoke-free workplace. Drug screening and background investigation are required, as allowed by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.