Scope of Work
The Social Services Agency desires to obtain the services of a four full time IT Database
Administrator II – General.
Tasks Data – IT Database Administrator II - General
Conduct general database management using understanding of business rules and troubleshoot servers. Perform daily system and MS SQL and PL/SQL error log checks and analyze job failures collected from monitor program. Provide analysis results to developers to address job issues to ensure that system/application is operating properly. Maintain availability and disaster recovery by coordinating with other IT group for Oracle and SQL Server databases backups. Perform daily checks and validations on the backup status for all major database servers. Perform MS SQL/PL SQL codes review and walkthroughs with developers to correct poorly written performance scripts. Plan and launch database move-ins into a production database environment. Review overall database performance after database scripts/objects are launched into production to avoid negative impact on applications and business users. Responsible for performance optimization and data replication services by performing tasks for the partitioning table and tuning index/data achievement for optimizing MS SQL and/or PL/SQL performances. Create, maintain and perform troubleshooting for SQL replication and ensure data is correctly replicated among database servers. Research latest database-related technological solutions to improve current database service availabilities through the design, testing and deployment of new solutions that co-exist with the existing environment. Work with Information Security Department to secure database environment. Database Administrator is responsible for the maintenance of existing applications and/or databases and for providing services to support project development. These services include but are not limited to consultation, analysis, physical/logical data model design, MS SQL, Oracle PL/SQL, database/application
performance tuning, quality assurance, planning and methodology, training, and using application developer programming tool set.
SSA Assignments- Preferred Skills for all four candidates:
Preferred candidates will have 5+ years IT operation with strong understanding of Microsoft SQL Server, Oracle, and MySQL databases structures, theories, principles, and practices. Understanding of, and experience with, server-client computing and relational database environments. Knowledge and experience with data management, data processing flowcharting techniques, reporting and query tools and practices. Good understanding of the Social Services Agency’s organizations goals and objectives. Good interpersonal, written, oral communication, technical documentation skills. Self-motivated and directed, with keen attention to detail. Experience working in a team-oriented, collaborative environment and able to prioritize and execute tasks in a high-pressure environment. Create new databases and maintaining existing databases based on required specifications. Plan databases growth and changes (i.e. database server disk space capacity planning). Create, implement, and maintain unit tests of database programs (i.e. SQL scripts, etc). Share knowledge by effectively documenting work. Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution. Resolve database performance issues, database capacity issues, replication, and other distributed data issues. Design and implement data models and database designs into databases. Manage security of database structures and corporate data held within databases. Develop database store procedures, triggers and SQL scripts for development teams. Maintain database changes from Development, Training, and Staging/QA to Production. Assist in the definition and implementation of database standards. Monitor databases for errors and perform problem determination when necessary. Design and implement highly available production systems. Establish, develop, and maintain backup and recovery policies and procedures. Interface with vendors for technical support. The candidate is responsible in data cleansing, loading, and reorganizing. Establish users database access profiles and connectivity. Develop, implement, and test automation scripts for database backup, recovery, and data download processes. Deliver quality project support and consulting services to development teams. Create primary database storage structures and primary objects. Provide and manage user access to the database. Perform database tuning and monitoring. The candidate will maintain and ensure compliance with all County database standards. Communicate and coordinate between development teams on project implementations affecting major shared data objects. Modify databases structures and work/share knowledge with other database administrators to bridge logical and physical data design differences. Maintain high customer satisfaction on databases performances. Assist application developer in tuning web applications.
Oracle Database Administrators preferred skills:
Strong working knowledge of Oracle 10G/11G and experienced in:
Planning, creating, and maintaining California Work Opportunity and Responsibility to Kids Information Network (CalWIN) and Child Welfare Services/Case Management System (CWS/CMS) databases using Microsoft operating system environment and Oracle 10G/11G for Data Mart, Data Warehouse, and Operational Data Store utilization
Planning, creating, and maintaining Service Center and custom applications Data Mart, Data Warehouse, and Operational Data Store databases using Microsoft operating system environment and Oracle 10G/11G.
Implementing CalWIN, CWS/CMS, and Service Center new versions/releases into Data Mart, Warehouse, and Operational Data Store databases
Installing, configuring, and upgrading of Oracle servers software and related products.
Evaluating Oracle features and related products.
Assisting in setting and exercising standards and procedures for the effective utilization of the agency’s Oracle databases.
Installing and upgrading Oracle software and other related tools (i.e. Oracle Discoverer).
SQL Server and MySQL Database Administrators preferred skills:
Strong working knowledge of SQL Server 2005/2008/2008R2/2012, MySQL, and experienced in:
Planning, creating, and maintaining Social Services Agency’s intranet/universe/extranet SQL Server databases
Planning, creating, and maintaining Social Services Agency’s Content Management System (Drupal) MySQL databases
Planning, creating and maintaining databases on VM and Physical servers environment
Installing, configuring, and upgrading of MySQL/SQL Server software and related products.
Evaluating MySQL/SQL Server features and related products.
Assisting in setting and exercising standards and procedures for the effective utilization of the agency’s MySQL/SQL Server databases.
Specific Project Skills Preferred:
Oracle Database Administrators - preferred experience for two candidates: Knowledge of CalWIN County Information Server (CIS) and Management Reporting (MR) Systems, CWS/CMS System, and Social Services Agency’s Data Mart, Warehouse, and Operational Data Store’s databases structures design; Knowledge of Oracle Discoverer and Business Objects administration; Experience in using Crystal Reports XI for reporting development, TOAD and CWS/CMS X-Tool. Knowledge of SQL Server 2005/2008/2008R2/2012 is a plus to backup SQL Server database administrators that support Social Services Agency’s Intranet, Universe, and Extranet custom applications databases. Preferred candidate would have experience in comprehensive analysis of Social Services Agency’s business rules and technical documentation related to CalWIN and CWS/CMS systems data structures. Preferred candidate with knowledge and experience using California Work Opportunity and Responsibility to Kids Information Network (CalWIN) and Child Welfare Services/Case Management System (CWS/CMS) state mandated systems data for custom applications systems interfaces and reports extracts development.
SQL Server/MySQL Database Administrators - preferred experience for two candidates:
Databases administration of Social Services Agency’s (SSA)Service Center’s Task Management System, SSA Report Portal, Barcode Generator System, Folder Tracking System, Cash Assistance Program for Immigrants System (CAPI), MEDS Viewer System, SMART Inquiry, CDS History System, Partners Data Interchange System (PDIS), Clerical’s Task Tracking System, CalWIN Assistant Pack Tool, IEVS Specialized Unit Task Management System, e-Personnel/Attendance System, Contractor training Tracking, and Workload Management System.
Preferred candidate with knowledge and experience using California Work Opportunity and Responsibility to Kids Information Network (CalWIN) and Child Welfare Services/Case Management System (CWS/CMS) state mandated systems data for custom applications systems interfaces and report extracts development.
Preferred candidate with knowledge and experience in developing and supporting Social Services Agency Drupal’s MySQL databases.
Databases Administration of Assessment Intervention Management System, Contracted Services System, Family Self Sufficiency Program Staffing & Statistics System, Integrated Continuing Services Statistics System, In-Home Support Services System, Phonebook System, and Supplemental Security Income Advocacy System, MediCal Assignment Board System, Multi-Agency Intervention Data System, Santa System, Adult Services & Assistance Program Staffing & Statistics System, Foster Youth Information System, Human Resources Activity Log System, Human Resources Mail Log System, Medi-Cal Referral Database System, Foster Care Stats System, CRO (Central Regional Office) Continuing Assignment Board System, Independent Living Program System, Initial Services Assignment Board System, and Exempt Assignment Board System.
Database administration of Social Services Agency’s Case Accuracy Review System, Change Control Management System, Child Abuse Registry Statistics Application, Differential Response Tracking System, Mandated Reporter Application, Online Manual System, Orangewood Children’s Information System, GRWP (General Relief Work Program) Client Data System, Independent Living Program Secure Communication, Personnel Tracking System, Program Integrity Case Statistics System, Overpayment Review Case Statistic System, Human Resources Management System, Secure Communication Management System, Adoptions Services Registry System, Adoptions Matching System, Reports to Social Workers System, Child Abuse Services Team System, Foster Care Training System, and Foster Care Conference System.
Experience in using Spotlight.
JobsDirectUSA - 16 months ago