| Sybase, SQL Server DBA at Lansing, Michigan, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1324902&uid= From: Satyam Gond, Tek InspirationsLLC [email protected] Reply to: [email protected] Hi, Hope you are doing great!!! Please share suitable profiles. Job Description - Position Sybase/SQL Server DBA Location Lansing, MI (Hybrid) need local only Duration 1 year MOI Video Local candidates (strongly preferred) or willing to relocate at your own expense. Resource will be working a hybrid schedule from day 1 onsite two days per week Description: client, the Michigan Department of Corrections (DOC ) is looking for a Sybase/SQL DBA to assist with their Sybase 15.7. The DBA will 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 environment is predominantly Sybase with SQL Server. Client will be 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 their 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. The 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 clients 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 clients 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. Tasks 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. Design 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 and 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. Ensure and validate 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. 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. Perform troubleshooting of performance issues and provide required solution. 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. Skills Required 2-3 years - Experience with Sybase 2-3 years - Experience with SQL Server 2-3 years - Experience with migration from Sybase to SQL Server Experience with Windows Servers Experience with Unix/Solaris Regards, Satyam Gond Keywords: Michigan Sybase, SQL Server DBA [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1324902&uid= |
| [email protected] View All |
| 04:42 AM 19-Apr-24 |