Support and maintain all enterprise databases and environments with a focus on providing high performance availability. This includes database development, information ETL, administration, maintenance, and troubleshooting to all PacificSource departments and subsidiaries. Assist other Information Technology staff with database-related tasks.
Work Experience:Minimum 3 years of intensive database administration in an enterprise environment, working as a professional DBA. Commercial and/or Medicare health care insurance industry systems experience preferred.
Education, Certificates, Licenses: BS in Computer Science, Information Systems, MIS or similar or equivalent combination of education and experience. System vendor certifications such as MCSA or MCSE in Data Management and Analytics or Cloud Platform and Infrastructure or AWS Associate-level certification, or similar preferred.
Knowledge: Microsoft SQL Server, SQL Stored Procedure Development, T-SQL, SQL Server Management Studio, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services, Microsoft SQL Server Integration Services, Microsoft Power Suite (PowerView, PowerPivot, PowerQuery), Microsoft Master Data Services and Data Quality Services, Dell/Quest Lightspeed, Spotlight and Foglight, Informatica. Additional desired experience includes Azure SQL Database, Azure Data Warehouse, AWS RDS, AWS Redshift, Cognizant/TriZetto Facets; EDI (ANSI x12 formats), HL7, and integration of enterprise wide applications.
Ability to respond to common inquiries and effectively present information to a variety of groups. Requires excellent interpersonal skills and ability to work closely with others as well as independently. Database normalization skills. Proficiency in word processing, spreadsheets, and other common office software tools, including Microsoft Office. Interest in ongoing training and learning about technology. Excellent written and verbal communication skills. Basic math skills, including fractions, percentages, ratios, and proportions. Ability to read, analyze, and interpret technical journals, financial reports, and legal documents.
Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately _5_% of the time. Requires some activity outside normal working hours. Requires ability to be on-call.
Physical Requirements: Stoop and bend. Sit and/or stand for extended periods of time while performing core job functions. Repetitive motions to include typing, sorting and filing. Light lifting and carrying of files and business materials. Ability to read and comprehend both written and spoken English. Communicate clearly and effectively.
Disclaimer: This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times.
PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, sexual orientation, gender identity or age.