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.
• 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, analyse, 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, analyse 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.
• Analyse and resolve database space utilization in production environments.
• Analyse and resolve issues with database integrity in development, test, and production environments.
• Perform troubleshooting of performance issues and provide required solution.
• Analyse 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.

Job Types: Full-time, Contract

Pay: $50.00 - $55.00 per hour

Experience:

• Sybase and its versions: 4 years (Required)
• Azure Cloud: 4 years (Required)
• Data Migration: 4 years (Required)

Ability to Relocate:

• Lansing, MI 48917: Relocate before starting work (Required)

Work Location: In person