Database Administration Specialist 2 ( 20024734)

Requirements

• Design, develop, test, implement, and support complex platform-specific ELT code using tools such as Python, SQL and Snowflake.
• Perform data migrations and design business process monitoring solutions.
• Implement high-availability and disaster-resilient solutions across multiple data warehouse and reporting environments.
• Provide Tier II technical support for database and ELT issues, including performance, availability, data integrity, security, and customer-reported concerns.
• Conduct performance tuning across multiple environments and platforms.
• Design standards for data exchange between internal systems and external entities, including data security models, encoding schemes, and data layouts.
• Define and support Data Warehouse business intelligence designs.
• Assist in implementing Data Warehouses and data marts.
• Implement custom SQL solutions and data extracts for business customers.
• Build and support enterprise reporting, dashboards, scorecards, and analytic applications (e.g., Python, SQL).
• Replicate and transform data to support analytics and BI initiatives.
• Develop and maintain documentation, including installation procedures, monitoring guides, security policies, configuration changes, and migration processes.
• Write platform-specific code to support data migrations across development, UAT, performance, beta-production, and production environments.
• Work closely with the Data Warehouse Architect, IT Architecture team, CIO, and IT Managers to design solutions that meet enterprise requirements.
• Assist in evaluating solution designs, new technologies, and industry best practices.
• Mentor database administration specialists and junior ELT developers through both formal and informal training.
• Contribute to business cases and solution documentation.
• Create, monitor, and resolve trouble tickets, ensuring timely updates and communication of remediation progress.
• Prepare and submit weekly activity and status reports.

Benefits

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)