Automates the creation and maintenance of databases for all environments.
Provides primary DB support for implementing, upgrading, and maintaining the DBMS (Oracle) environments.
Develops new technologies and techniques to optimize database stability, resilience, and security.
Monitors and resolve application connectivity and DB interface issues; proactively working with other support teams to ensure that application problems do not adversely affect production operations.
Collaborates with application developers and vendors to report and resolve problems.
Implements and tests database backup and recovery technology / procedures for database environments.
Mentors and educates HealthPartners technical staff, DB users and vendors in techniques to optimize query performance.
Ensures compliance of all DB security standards in collaboration with IS&T Security Management.
Debugs problematic database issues, provide analysis for future enhancements and development; proactively maintaining effective and efficient database structures and system processing.
Forecasts and analyzes future capacity needs and develops tools and utilities to mitigate future capacity issues.
Required Qualifications:
4-year college degree in Computer Science, Math, Engineering, or related field OR 3+ years IS&T related experience
Self-learner with strong desire to solve hard problems
2+ years’ experience with DevOps or database administration
2+ years’ experience SQL and PL/SQL or T-SQL programming
2+ years’ experience with Unix shell, Perl, or OS scripting language
2+ years’ experience with performance tuning
Strong knowledge of operating systems (i.e., Windows, Linux)
Excellent oral and written communication skills
Experience with database backup and recovery
Available to work outside normal business hours, including weekends and be on-call (7 days x 24 hours)
Effectively use Microsoft tools, including Outlook, Word, Excel, Visio, and PowerPoint