• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Database Administrator 2

In United States

Save this job

Database Administrator 2   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Database Administrator 2

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Lansing, MI United States

JOB DESCRIPTION:

Position: Database Administrator 2

REQ ID: 102593

Client Name:  State of Michigan -  IT - DTMB - Agency Services - MDOT

Job Location:  Lansing, MI

 

Top Skills & Years of Experience:
- SQL
- Provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.
- This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies.

 

Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share a screen if asked.
Duration: 1 year with possible extension.
Remote or On-site: Candidates MUST be located in MI. (Local preferred) Will need to be onsite starting May 2nd for a 2-day a week hybrid schedule.

 

General Summary of Function/Purpose of Position

 

As a Senior Database Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database systems for (insert agency name/database application). This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies. Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.

 

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.

 

Individual tasks related to the duty.

· 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.

· 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.

· 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.

· 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.

· 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.

· Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.

· Analyze databases for optimal performance and investigate poorly performing SQL statements and offending database sessions. Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods. Document tuning procedures.

· Perform thorough analysis and investigation to resolve locking conflicts. (For example: Locking conflicts can be shared or exclusive. Shared involve multiple users accessing the data or table at the same time. Exclusive is when only one user or process can access the data at a time. Locking conflicts can also be at different levels and an incorrect resolution can cause corruption or loss of data.)

· Analyze and resolve issues related to undo/redo/transaction log configuration and sizing in development, test and production environments.

· Analyze and resolve server generated and threshold-based alerts. Perform resolution for the alert causes and provide recommendations for setting up appropriate alert thresholds.

· Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances.

· Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary. 

· Agrees to follow all policy, standards, and procedures of DTMB.

 

Individual tasks related to the duty.

· 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.

· Recommend standard password security policies

· Review, install, analyze, and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and Michigan Cyber Security compliant.

 

Position Details

POSTED:

Aug 01, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S1650585618873564

LOCATION:

United States

CITY:

Lansing, MI

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Database Administrator 2    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<div> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif"><span style="text-align:justify">Position: </span>Database Administrator 2</font></b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif"><span style="text-align:justify"><span style="color:black">REQ ID: </span></span>102593</font></b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><b><font face="verdana, sans-serif"><span style="text-align:justify">Client Name: <span style="line-height:12.1267px"><span style="color:black"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"> State of Michigan - </span></span></span></span></span></span></span></span></span> IT - DTMB - Agency Services - MDOT</font></b></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif"><b><span style="text-align:justify">Job Location: </span> Lansing, MI</b></font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"> </p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b>Top Skills & Years of Experience:</b><br style="font-weight:400" /> <span style="font-weight:400">- SQL</span><br style="font-weight:400" /> <span style="font-weight:400">- Provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.</span><br style="font-weight:400" /> <span style="font-weight:400">- This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies.</span></font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"> </p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b>Interview Process:</b><span style="font-weight:400"> Virtual Interview via MS Teams video. Please use laptop and be prepared so share a screen if asked.</span><br style="font-weight:400" /> <b>Duration:</b><span style="font-weight:400"> 1 year with possible extension.</span><br style="font-weight:400" /> <b>Remote or On-site:</b><span style="font-weight:400"> Candidates MUST be located in MI. (Local preferred) Will need to be onsite starting May 2nd for a 2-day a week hybrid schedule.</span></font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"> </p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-weight:bold"><font face="verdana, sans-serif">General Summary of Function/Purpose of Position</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px; margin-left:30px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="font-weight:bold"><font face="verdana, sans-serif"> </font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:4px; margin-left:30px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">As a Senior Database Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database systems for (insert agency name/database application). This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies. Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif"> </font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif">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.</font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif"> </font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif">Individual tasks related to the duty.</font></b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Research, draft and recommend database standards and policies.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Coordinate with vendor support to address technical issues that could not be resolved in-house.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Participate in the planning process to match emerging technologies with future business needs. </font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Calculate disk space requirements for existing and/or new installations and growth based on changing business requirements. </font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· 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.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Design appropriate strategy to reorganize database objects to release unused space or repair fragmentation.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Install database management software in any environment</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Install database patches and service packs in any environment.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· 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.</font></span></span></span></span></span></span></span></span></span></span></span></p> <ul style="color:#222222; font-family:Arial, Helvetica, sans-serif; font-size:small; font-style:normal; font-variant-ligatures:normal; font-weight:400; text-align:start; white-space:normal; background-color:#ffffff; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial" type="disc"> <li style="line-height:normal"><font face="verdana, sans-serif">Define/design roles and profiles.</font></li> </ul> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Implement data encryption.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Design, configure, and initiate auditing with appropriate options as needed.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Create and deploy new database in development and test environments.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Ensures and validates the integrity and quality of the scripts to be promoted to any of the environments.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Perform Data Export/Import/Load and data transformations between databases in production environments.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Analyze and resolve database space utilization in production environments. Analyze and resolve issues with database integrity in development, test, and production environments.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· 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.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Analyze databases for optimal performance and investigate poorly performing SQL statements and offending database sessions. Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods. Document tuning procedures.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Perform thorough analysis and investigation to resolve locking conflicts. (For example: Locking conflicts can be shared or exclusive. Shared involve multiple users accessing the data or table at the same time. Exclusive is when only one user or process can access the data at a time. Locking conflicts can also be at different levels and an incorrect resolution can cause corruption or loss of data.)</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Analyze and resolve issues related to undo/redo/transaction log configuration and sizing in development, test and production environments.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Analyze and resolve server generated and threshold-based alerts. Perform resolution for the alert causes and provide recommendations for setting up appropriate alert thresholds.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary. </font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· <span lang="EN-US" style="color:black">Agrees to follow all policy, standards, and procedures of DTMB.</span></font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span lang="EN-US" style="color:black"><font face="verdana, sans-serif"> </font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-top:3px; margin-bottom:3px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif">Individual tasks related to the duty.</font></b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:24px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:24px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Research, analyze, and determine appropriate hardware changes to support future application and database needs. Report recommendations to appropriate DBA specialist and/or technical services.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:24px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Review results of database integrity checks. Resolve identified issues.</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Recommend standard password security policies</font></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-left:48px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif">· Review, install, analyze, and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and Michigan Cyber Security compliant. </font></span></span></span></span></span></span></span></span></span></span></span></p> </div> <div> </div>


Please wait..!!