Sybase DBA
•9 days ago
Estimated Pay | $39 per hour |
---|---|
Hours | Full-time, Part-time |
Location | Lansing, MI, United States Lansing, Michigan |
Compare Pay
Estimated Pay We estimate that this job pays $38.98 per hour based on our data.
$26.45
$38.98
$65.48
About this job
Job Role: Sybase DBA
Location: Lansing-MI (Hybrid) – Locals only
Duration: 1+ Years
Interview: MS Teams
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
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.
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.
You might also like
in Lansing, MI
$4,500 - $6,000
Trans Quality DBA as UC Carrier • 3d ago
$25
Trans Quality DBA as UC Carrier • 4d ago
$13
BMR Michigan LLC. DBA Little Caesars • 20h ago
$67
EGROVE SYSTEMS CORPORATION • 20h ago
$67
EGROVE SYSTEMS CORPORATION • 20h ago
Companies hiring network architects
in Lansing, MI
Nearby locations
Explore more network architect jobs
in Lansing, MI
Nearby Job Titles
Driver Jobs Automotive Detailer Jobs Food Service Supervisor Jobs Nurse Practitioners Jobs Retail Supervisor JobsNearby Locations
Lansing, MI Jobs Charlotte, MI Jobs East Lansing, MI Jobs Okemos, MI Jobs Michigan JobsNearby Companies
Shipt Jobs MRG Exams Jobs DoorDash Jobs Arby's Jobs ALDI JobsNearby Categories
Full-time Jobs Part-time Jobs Gig Jobs Posting ID: 930887651 Posted: 2024-04-20 Job Title: Sybase Dba