Jobs
>
Lansing

    Role: Database Administrator - Lansing, United States - TMS Services

    Show more Collapse job
    Default job background
    Description

    Company Description

    Job Description

    Role:
    Database Administrator


    Duration:
    Long Term (W2 only)


    Location: 235 South Grand Ave., Lansing, Michigan need nearby candidate within 50 to 60 miles)

    Work Arrangement:
    Hybrid 3 days office 2 days remote

    Experience: 10 + years


    Top Skills & Years of Experience:

    • Candidates must have experience with migration from Sybase to SQL Server (23 years minimum experience with Sybase and SQL)
    • Candidates must be experienced in troubleshooting.
    • Unix/Solaris experience
    Job Description -
    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 afterhours 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.

    Qualifications

    Additional Information

    All your information will be kept confidential according to EEO guidelines.

    We have other current jobs related to this field that you can find below


  • Pan Asia Resources Lansing, United States

    Job Title Database Administrator - SQL/Sybase · Location Lansing, Michigan · Database Administrator 5 · We are looking for a team-oriented person with a deep understanding of database administration (SQL Server and Sybase) to help support MDOC. Above all we are looking for someon ...


  • Creative Financial Staffing (CFS) Lansing, United States

    Job Description · Job DescriptionPosition: Database Administrator · Location: East Lansing, MI (Onsite) · A privately held organization in the financial industry located near the East Lansing, MI area is seeking a full-time, permanent Database Administrator to be an integral part ...


  • Ageatia Global Solutions Lansing, United States

    Job Description - · 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 s ...


  • NR Consulting Lansing, United States

    Job Requirements: · • · 8+ years' experience · - Bachelor's Degree · - Please see all requirements that are needed in the attached position description. Candidates must meet these requirements. · Requirements: · •Experience in Oracle 19c /SQL Server Database Administration, Requi ...


  • Global Pharma Tek Lansing, United States

    Job Title: Database Administrator · Duration: 1 Year (High chance of extension) · Location: Lansing, MI (Hybrid) · Description of work: · 1. Responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and l ...


  • CFS - Technology East Lansing, United States

    Job Description · Job DescriptionJob Title: Database Administrator · Location: East Lansing, MI (Onsite) · Job Type: Full-time, Permanent · About the Company: A privately held organization in the financial industry located near the East Lansing, MI area is seeking a full-time, pe ...


  • Tekfortune Inc Lansing, United States

    Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for worlds leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the ...


  • Velocity Enterprises Dimondale, United States

    We are in need of innovative spirit and creativity for effective protection. The German Patent and Trademark Office (DPMA) is the competence center for all industrial property rights - for patents, utility models, trademarks, and designs. · With the further development of our pro ...


  • Creative Financial Staffing East Lansing, United States

    Job Title: Database Administrator · Location: East Lansing, MI (Onsite) · Job Type: Full-time, Permanent · About the Company: A privately held organization in the financial industry located near the East Lansing, MI area is seeking a full-time, permanent Database Administrator to ...


  • Hudson Data Lansing, United States

    Job Title: Oracle Database Administrator 5 · Location: Lansing, MI ( Hybrid ) · Duration: Long Term · 40 Hrs Job · Description: · General Summary of Function/Purpose of Position: · As a senior Database & Services Administrator, the employee performs a complete range of informati ...


  • Creospan Private Limited Okemos, United States

    Profile & Description: · Monitors the day-to-day activities of production and non-production database systems to ensure smooth operation of all environments. This includes space administration within the database and at the operating system level to ensure the database systems pe ...


  • Tech Tammina LLC Okemos, United States

    Job Description · Job DescriptionRole: Senior Oracle Database Administrator · Location: Okemos, MI (Need Locals) · Duration: Long term · Rate: Market · Profile & Description · Monitors the day-to-day activities of production and non-production database systems to ensure smooth op ...

  • Michigan Farm Bureau

    IT Data Architect

    3 weeks ago


    Michigan Farm Bureau Lansing, United States

    · IT Data Architect · US-MI-Lansing · Job ID: · Type: Regular Full-Time · # of Openings: 1 · Category: Information Technology · Farm Bureau Center · Overview · IT Data Architect Objective · To provide advanced technical support in the research, analysis and application of syste ...


  • Evolutyz Corp Lansing, United States

    Hybrid role at Lansing, MI, Locals preferred. · Experience in applications design and programming. Will accept any suitable combination of education, training, or experience. · Position requires 5+ years of advanced knowledge of SAS programming and administration · 3+years of rel ...


  • Michigan State University East Lansing, United States

    Working/Functional Title · Shared Discovery Administrator · Position Summary · This position provides support to the Shared Discovery Curriculum in the College of Human Medicine; Provides support for all aspects of the external clinical experience. Provides information and assi ...

  • Genoa Employment Solutions

    SAS Consultant

    4 days ago


    Genoa Employment Solutions Lansing, United States

    Description: · Genoa Employment Solutions is currently seeking a SAS Programmer to support several reporting platforms. In this role, you'll create Excel and PDF reports using Base SAS as described by business requirements documents and test system components. · Responsibilities: ...

  • InsideHigherEd

    Data Resource Analyst

    3 weeks ago


    InsideHigherEd East Lansing, United States Administrative Jobs ,

    Job no: 955583 · Work type: Support Staff · Pay Grade: 13 · Major Administrative Unit / College: Msu Agbioresearch · Department: Abr Directors Office · Sub Area: AP- Professionals · Salary: Salary Commensurate with Experience · Location: East Lansing · Categories: Administrative ...


  • InsideHigherEd East Lansing, United States

    Job no: 957896 · Work type: Support Staff · Pay Grade: 12 · Major Administrative Unit / College: College Of Social Science · Department: Social Science Dean · Sub Area: AP- Professionals · Salary: Salary Commensurate with Experience · Location: East Lansing · Categories: Adminis ...

  • Michigan State University

    NRE Journalist

    1 week ago


    Michigan State University East Lansing, United States

    Working/Functional Title · NRE Journalist · Position Summary · The National Registry of Exonerations (NRE) is a project of the Michigan State University College of Law, the Newkirk Center for Science and Society at University of California Irvine and the University of Michigan ...


  • InsideHigherEd East Lansing, United States Administrative Jobs ,

    Job no: 953667 · Work type: Support Staff · Pay Grade: 13 · Major Administrative Unit / College: College Of Engineering · Department: Engineering Research Division Of · Sub Area: APSA- Pro Supervisory · Salary: Salary Commensurate with Experience · Location: East Lansing · Categ ...