Database Administrator jobs in Lansing, MI

• 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.
  
• Work with clusters and with Disaster Recovery in our development, test, and production environments.
  
  
  

Requirements

• Experience with Sybase and SQL
  

Desired Skills

• Assist with tasks, particularly during after hours implementations that the senior DBAs need completed to reduce the overall time required per DBA. 
  

Minimum Education

• None
  

Location

• Local candidates (strongly preferred) or non-local (must be willing to relocate/follow the hybrid schedule).
  
• Position is a hybrid schedule with 2 days per week required to be on-site, with rest of the time remote
  
• 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. 
  

Additional Requirements

• Must be authorized to work in the United States; We are unable to offer sponsorships at this time
  
• Must undergo a background check and drug screening for employment.
  

Employment Terms

• This is a W2 position
  
• 40 hrs per week
  
• HYBRID schedule - will need to be onsite from day 1, two days a week. Wednesdays are required to be onsite. NO REMOTE ONLY OPTION
  
• Overtime and weekend work is rare and must be scheduled and approved by our customer. This is generally a scheduled project.
  

Benefits