Database Administrator

Role Overview

• Perform advanced database administration and management functions in support of highly complex applications characterized by sophisticated data models, multi-stage workflows, and extensive reporting requirements.
• Provide expert leadership in the design, development, maintenance, optimization, and migration of integrated database systems, ensuring that applications conform to enterprise structural and security standards.
• Enter codes and scripts to create and maintain production databases and associated objects.
• Select and configure utility programs and jobs to monitor database performance.
• Analyze, design, modify, and maintain logical and physical database structures in support of application and reporting requirements.
• Design and implement procedures necessary to save, retrieve, and recover databases from hardware and software failures.
• Execute backup, restore, and recovery procedures to ensure database availability, reliability, and data integrity.
• Support installation, configuration, and upgrades of database software and migrations to new data management system levels; test and validate migrations.
• Assist in the selection and evaluation of database management software and related tools.
• Provide assistance in the planning, development, implementation, and maintenance of data warehouses, data marts, and decision support environments.
• Perform performance tuning and optimization of database and data warehouse environments.
• Monitor database and data warehouse performance, identify bottlenecks, and recommend and implement efficiency improvements.
• Create test database environments for application and reporting teams.
• Maintain and govern the data dictionary, ensuring uniformity of definitions and establishing standards for its use across the organization.
• Maintain the security and integrity of critical infrastructure systems by preventing unauthorized access.

Requirements

• 4–7 years of experience in the database administration, data warehousing, or a closely related information systems field.
• Familiarity with standard concepts, practices, and procedures within the database and data warehouse management discipline.
• Demonstrated ability to rely on experience and judgment to plan and accomplish goals with limited supervision.
• Proven capacity to exercise creativity, initiative, and independent judgment in solving complex technical problems and optimizing database environments.
• Strong knowledge of database management systems (DBMS), as well as data warehouse management and decision support tools.
• Extensive experience in the development, implementation, and maintenance of data warehouses and data marts.
• Experience with business intelligence/analytics tools (e.g., Business Objects) and building and maintaining the data dictionary.
• Demonstrated ability to use database access tools to support application delivery and reporting.
• Strong familiarity with analysis, planning, and management reporting functions.
• Well-developed oral and written communications skills.
• Strong teamwork and interpersonal skills to collaborate effectively across technical and non-technical teams.
• Extremely high level of analytical ability to address very unusual and extremely difficult technical problems.
• Understanding of benchmarking processes and techniques for database and data warehouse environments.
• Very high level of interpersonal skills to work effectively with others, motivate teams, and elicit high-quality work output.
• Hands-on experience with GUI-based ETL tools such as: Informatica, IBM WebSphere DataStage, or similar enterprise ETL tools.
• Implementation experience with enterprise-class databases, such as: Teradata, Oracle, Microsoft SQL Server, or similar technologies.
• Implementation experience with analytical and reporting tools, such as: Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools.
• Experience with the complete data warehouse implementation process, including: Business requirements analysis, Logical data modeling, Physical database design, Data sourcing and data transformation, Data loading and ETL processes, Structured Query Language (SQL) development and optimization, End-user tools and reporting/analytics, Database and SQL performance tuning.

Tech Stack

• Cognos
• ETL
• Informatica
• MS SQL Server
• Oracle
• SQL

Benefits

• Medical, Dental and Vision Insurance;
• Wellness Program
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short-Term and Long-Term Disability options
• Basic Life and AD&D Insurance (Company Provided)
• Voluntary Life and AD&D options
• 401(k) Retirement Savings Plan with matching after one year
• Paid Time Off