Talent.com
Database Administrator 4
Database Administrator 4My3Tech Inc • Lansing, MI, United States
Database Administrator 4

Database Administrator 4

My3Tech Inc • Lansing, MI, United States
4 days ago
Job type
  • Full-time
Job description

Hello All,

I hope you're doing well.

Job : Lansing, MI - IT - DTMB - Agency Services - DOC - Database Administrator 4

Location : Lansing MI

Job ID : 129402

Client : State of MI

Type : C2C / W2

ginning of the interview to introduce the candidate to the manager.

The State of Michigan is looking for : Database Administrator 4

Duration : 1 year with extension likely

Will close submissions on : 4 / 22 / 2024 at 10am EST

Top Skills & Years of Experience :

  • Candidates must have experience with migration from Sybase to SQL Server (2-3 years minimum experience with Sybase and SQL)
  • Candidates must be experienced in troubleshooting.
  • Unix / Solaris experience

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

Prescreening questions are required for this position. These are attached and must be included in your submission.

Job Description - Posting 129402 - DOC - Database Administrator 4

We are looking for a DBA to join our team.

They will need to have experience with formal change control environments. They also need strong troubleshooting skills.

This position is for an expected 40 hours per week Monday through Friday with two days on site (Wednesdays are a mandatory onsite day). There is currently a rotation for on call during the period Saturday morning till Monday morning and this position may be required to assist with this after an initial learning period. Overtime and weekend work is rare and must be scheduled and approved by our customer. This is generally a scheduled project.

Our environment is predominantly Sybase with SQL Server. We are moving from Sybase to a pure SQL Server in approximately 3 years. The Sybase environment is 15.7 on Solaris in an X86 hardware environment within our local network. The SQL Server environment is mixed versions of SQL Server on mixed versions of Windows Server with an upcoming project to update versions. This environment includes both servers in our network and in Azure.

Our planned goal is to move off Sybase and a project to do this is underway and thus the need for the selected candidate to have some experience with both Sybase and SQL Server.

Our primary goal is to have an additional individual to assist with our Sybase 15.7. As a result, the appropriate candidate will need to have Unix background running and developing CRON jobs with command line experience. The DBA should be familiar with Sybase ASE 15.7. This can be at the level of a junior DBA. The desire is to have a DBA that can assist with tasks, particularly during after hours implementations that the senior DBAs need completed to reduce the overall time required per DBA. This position will also help with other tasks that occur during the week such as weekly data fixes which occur on Thursday and Friday.

The secondary goal is to take work off the SQL Server DBAs. This will require the individual to have some experience with Windows Servers and with SQL Server. Additionally, the person will work with clusters and with Disaster Recovery in our development, test, and production environments.

A strong desired experience is migration from Sybase to SQL Server.

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.
  • 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.
  • Review, install, analyze and implement security patches to be applied to remain PCI compliant, vendor compliant, and OES 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.
  • Define / design profiles.
  • Recommend standard password security policies.
  • Implement data encryption (13+design 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 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.
  • Perform troubleshooting of performance issues and provide required solution.
  • 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.
  • 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. Document solution and provide root cause analysis.
  • Create a job alert for this search

    Database Administrator • Lansing, MI, United States

    Similar jobs
    Database Administrator 4

    Database Administrator 4

    Kyyba • Lansing, MI, United States
    Full-time
    Are you a Database Administrator 4 seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented Database Administrator 4 to join their growing team in.Foun...Show more
    Last updated: 4 days ago • Promoted
    SQL Database Administrator at Lansing, MI- In-Person Interview, Only Locals

    SQL Database Administrator at Lansing, MI- In-Person Interview, Only Locals

    RICEFW Technologies • Lansing, MI, United States
    Full-time
    State of Michigan - Center for Educational Performance and Information (CEPI).The State of Michigan's Center for Educational Performance and Information (CEPI) is seeking an experienced.SQL Databas...Show more
    Last updated: 4 days ago • Promoted
    Oracle DBA

    Oracle DBA

    Georgia IT Inc • Lansing, MI, United States
    Full-time
    Database administration specifically on the oracle platform, version 19c and above.Solaris and Red Hat Linux experience required.Show more
    Last updated: 4 days ago • Promoted
    Oracle Database Administrator 5

    Oracle Database Administrator 5

    InterSources • Lansing, MI, United States
    Full-time
    Job Title : Oracle Database Administrator 5 Location : Lansing, MI , Hybrid.Top Skills & Years of Experience : .Oracle Database Administration (19c or higher). Candidates MUST be able to speak to skill...Show more
    Last updated: 4 days ago • Promoted
    Data Warehouse Architect

    Data Warehouse Architect

    InterSources • Lansing, MI, United States
    Temporary
    Duration : 12 Months Contract Position.Responsible for the complex Linux security model on DW ETL servers.Servers are administered by another group, but our team is responsible for the security stru...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator 2

    Database Administrator 2

    Sunrise Systems • Lansing, Michigan, United States
    Full-time
    Quick Apply
    Job Title : Database Administrator 2.Internal Reference ID : 25-05788.Location : Lansing, MI (Hybrid).The position is responsible for providing Infrastructure DBA support for all SQL Server applicatio...Show more
    Last updated: 30+ days ago
    Database Administrator 5

    Database Administrator 5

    Kaav Inc. • Lansing, MI, United States
    Full-time +1
    We are looking for a DBA to join the team.This is not a short-term contract.We would prefer to eventually move the person to being a full-time employee, if possible, but the primary goal is to have...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator

    Database Administrator

    Nanosoft Consulting • Lansing, MI, United States
    Full-time
    About the job Database Administrator.The Department of Technology, Management and Budget supports the business operations of the state agencies through a variety of services including Information T...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator 3 - SQL Server DBA (Only Local to MI)

    Database Administrator 3 - SQL Server DBA (Only Local to MI)

    Inficare • Lansing, MI, United States
    Full-time
    Title : Database Administrator 3 - SQL Server DBA.Location : Lansing, MI, 48933 (2 Days Onsite per week).Interview : Virtual Interview via MS Teams with the possibility of 2nd round interviews being h...Show more
    Last updated: 4 days ago • Promoted
    Lansing, MI - IT - DTMB - Agency Services - DOC - Database Administrator 4

    Lansing, MI - IT - DTMB - Agency Services - DOC - Database Administrator 4

    InstantServe LLC • Lansing, MI, United States
    Full-time
    Position Description : Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate's resume wit...Show more
    Last updated: 4 days ago • Promoted
    Lansing, MI - IT - DTMB - Agency Services - DHHS - Database Administrator 2

    Lansing, MI - IT - DTMB - Agency Services - DHHS - Database Administrator 2

    Tekfortune Inc • Lansing, MI, United States
    Full-time
    Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate's resume with full legal first nam...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator III / Developer

    Database Administrator III / Developer

    ASM Research, An Accenture Federal Services Company • Lansing, MI, United States
    Full-time
    Provides database support by verifying databases associated with network tools and solutions function as required.Responsible for managing the routine operations and maintenance of databases and en...Show more
    Last updated: 4 days ago • Promoted
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    My3Tech Inc • Lansing, MI, United States
    Full-time
    Job : Lansing, MI - IT - DTMB - Agency Services - LARA - Database Administrator 5.Local candidates only - must be located within 2 hours of Lansing, MI. The State of Michigan is looking for : Database...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator 3 (Local to Michigan only)

    Database Administrator 3 (Local to Michigan only)

    Inficare • Lansing, MI, United States
    Full-time
    Title : Database Administrator 3.Location : Lansing, MI, 48933 (Hybrid - 2 Days Onsite / week & Local candidates only).Interview : 1st round - Virtual Interview via MS Teams video.Duration : 12 Weeks fro...Show more
    Last updated: 4 days ago • Promoted
    Lansing, MI - IT - DTMB - Agency Services - CEPI - Database Administrator 4

    Lansing, MI - IT - DTMB - Agency Services - CEPI - Database Administrator 4

    Syntricate Technologies • Lansing, MI, United States
    Full-time
    Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate's resume with full legal first nam...Show more
    Last updated: 4 days ago • Promoted
    Database Administrator 4

    Database Administrator 4

    Sunrise Systems • Lansing, Michigan, United States
    Full-time
    Quick Apply
    Job Title : Database Administrator 4.Duration : 1 year with possible extension.Top Skills & Years of Experience : .Someone with a combination of DBA, architect, and developer experience is a plus.S...Show more
    Last updated: 30+ days ago
    Database Administrator 2-IT

    Database Administrator 2-IT

    Oracle • Lansing, MI, United States
    Full-time
    Building off our Cloud momentum, Oracle has formed a new organization - Oracle Health Applications & Infrastructure.This team will focus on product development and product strategy for Oracle Healt...Show more
    Last updated: 4 days ago • Promoted
    SBO - Database Administrator 4

    SBO - Database Administrator 4

    InstantServe LLC • Lansing, MI, United States
    Full-time
    SBO - Database Administrator 4 - 146996.Duration : 1 year with extension likely.Desire for contractor to eventually convert to fulltime. Lansing MI - Hybrid : Resources will be working a hybrid schedu...Show more
    Last updated: 4 days ago • Promoted