The Orange County Information Technology department has an opportunity for an experienced, results-oriented IT Database Administrator II to support Orange County Information Technology initiatives and business functions.
Installs and tests new versions of database management systems; plans and implements upgrades; regularly tests hardware and software to ensure optimal functionality.
Designs, analyzes, develops, maintains and administers database solutions.
Develops support programs as needed to transfer, extract, transform and load data into databases and extract and transfer data between databases.
Plans, determines and implements database hardware/software configurations, taking into consideration both front end user accessibility and back end organizational needs.
Configure, maintain and ensure security of database servers, ETL servers, Report servers and databases.
Database performance tuning like locks, dead locks, query analyzer.
Create and Deploy ETL packages to database server using various control flow and data flow transformations
Evaluate database performance and perform maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
Create and deploy SSRS reports on report server and grant necessary permissions. Work as part of the production team and with project leads to coordinate data development and determine project scope to optimize the efficiency of the organization's business processes and manage projects to successful completion.
Run diagnostic tools to identify database performance bottlenecks and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
Implement and enforce database security based upon HIPAA regulations and industry best practices and county policies.
Research and respond to customer complaints regarding database functionality; troubleshoot failures and make corrections to ensure business continuity.
Write database documentation, including data standards, procedures and definitions.
Participate in disaster recovery exercise planning and execution
Location: Orange County, CA