Database Administrator 4 (Hybrid)
Company: DP Professionals
Location: Lansing
Posted on: April 19, 2024
Job Description:
DPP is seeking a Database Administrator for an opportunity in
Lansing, Michigan.
Work arrangement:
- Hybrid, two days per week on site (Wednesdays are mandatory
onsite)
- W2 position; 12 months with possibility of extension Position
description:
- The client's environment is predominantly Sybase with SQL
Server. The client is 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 the client's 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 the client's
network and in Azure.
- The client's 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.
- The client's primary goal is to have an additional individual
to assist with the client's 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 the client's
development, test, and production environments.
- A strong desired experience is migration from Sybase to SQL
Server. Top skills:
- 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 Responsibilities:
- 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. Interested? Learn more:
Click the apply button or contact our recruiter Mason at
Mason.Brown@dppit.com to learn more about this position
(#24-00284).
DPP offers a range of compensation and benefits packages to our
employees and their eligible dependents. Call today to learn more
about working with DPP.
Authorized US Worker - US Citizens and those authorized to work in
the US are encouraged to apply. We are unable to sponsor at this
time. EOE/AA/V/D
Keywords: DP Professionals, Southfield , Database Administrator 4 (Hybrid), IT / Software / Systems , Lansing, Michigan
Didn't find what you're looking for? Search again!
Loading more jobs...