Vacancy expired!
SummaryAs a senior Database & Services Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database and related systems services for production, test, and development environments for LARA applications. A senior Database Administrator plans, coordinates, and implements a full range of professional database & services administration functions for LARA as part of the database services team. Provides analytical and technical support and leadership around specialized software for database systems, developing database structures for applications, and related services such as job scheduling/automation & print/document management. Assists clients and agency staff, application development teams, data architects, and business data stewards. This position is also responsible for the support and maintenance of numerous databases and services. Responsible for the design, installation, and implementation of physical and virtual databases. Proactively monitor, write complex scripts, do performance tuning, and troubleshooting for an environment that requires a higher support level. This position will assist technical staff in researching about patches/upgrades, identification/troubleshooting, and resolution of database issues, and work with database security & compression tools. It is also responsible for assisting the planning, design, and implementation of security measures/tools which safeguard access to database files and data elements. Duties of the position:As a senior level information technology programmer/analyst, uses advanced principles and procedures of systems design methodology, structured systems design, and automated data processing techniques for new and existing complex computer applications.• Research, draft and recommend database standards and policies.• Coordinate with vendor support to address technical issues that could not be resolved in-house.• Participate in the planning process to match emerging technologies with future business needs.• Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.• Calculate disk space requirements for existing and/or new installations and growth based on changing business requirements.• Measure and/or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.• Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.• Research, analyze, and determine appropriate hardware changes to support future application and database needs. Report recommendations to appropriate DBA specialist and/or technical services.• Review results of database integrity checks. Resolve identified issues.• Design appropriate strategy to reorganize database objects to release unused space or repair fragmentation.• Install database management software in any environment• Install database patches and service packs in any environment.• Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.• Review, install, analyze, and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and Michigan Cyber Security compliant.• Designs the security model based on set standards. Create database user accounts and schemas in production environments based on defined and approved forms and procedures.• Define/design roles and profiles.• Recommend standard password security policies.• Implement data encryption.• Design, configure, and initiate auditing with appropriate options as needed.• Create and deploy new database in development and test environments.• Ensures and validates the integrity and quality of the scripts to be promoted to any of the environments. • Provide guidance to systems analysts, based on documented standards, in creating and modifying application specific database objects.• Perform Data Export/Import/Load and data transformations between databases in production environments.• Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.• Analyze and resolve database space utilization in production environments. Analyze and resolve issues with database integrity in development, test, and production environments.• Design and implement database backup solutions based on the business needs which include configuration, testing, implementation, modification, automation and monitoring of the backup and recovery solution as needed; troubleshoot and resolve more complex backup issues. Work with the Enterprise Backup and Recovery (EBUR) team to design and implement backup policy using available technology. Top Skills & Years of Experience:- Oracle Database Administration (12c or higher)- RAC (required)- Perform Patching and Updates- Vulnerability RemediationCandidates MUST be able to speak to skills listed on resume.Clear and concise written and verbal communication is crucial to success and productivity in this role. Location: Lansing, MIHybrid: Will need to be onsite from day 1, two days a week. Local candidates (strongly preferred) or non-local (must be willing to relocate).
- ID: #49041544
-
State: Michigan
Lansing
48915
Lansing
USA
- City: Lansing
- Salary: $65 - $70
- Job type: Contract
- Showed: 2023-02-06
- Deadline: 2023-03-25
- Category: Software/QA/DBA/etc