Database Administrator 4
2 weeks ago
Location: Lansing, MI ( Hybrid )
Duration: Long Term
40 Hrs 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.
This position is for an expected 40 hours per week Monday through Friday with two days on site (Wednesdays are a mandatory onsite day). 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. Overtime and weekend work is rare and must be scheduled and approved by our customer. This is generally a scheduled project.
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. s 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. dditionally, 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, 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.
-
Database Administrator 4
2 weeks ago
Lansing, United States Global Pharma Tek Full timeJob Title: Database Administrator Duration: 1 Year (High chance of extension) Location: Lansing, MI (Hybrid) Description of work: 1. Responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Knowledge of the utilities and...
-
Database Administrator
1 week ago
East Lansing, United States Creative Financial Staffing Full timePosition: Database AdministratorLocation: East Lansing, MI (Onsite) A privately held organization in the financial industry located near the East Lansing, MI area is seeking a full-time, permanent Database Administrator to be an integral part of their Site Reliability team! Here are a few reasons why you should apply: Outstanding culture with...
-
Database Administrator
1 month ago
Lansing, United States V2Soft Full timeTop Skills & Years of Experience: - Oracle Database Administration (c or higher) - RAC (required) - OEM - Perform Patching and Updates - Vulnerability Remediation - Bachelor's degree required - + years experience Candidates MUST be able to speak to skills listed on resume. Candidates must be willing to work overtime as needed. Hybrid: Will need to be...
-
Database Administrator
2 weeks ago
Lansing, United States Pan Asia Resources Full timeJob Title Database Administrator - SQL/Sybase Location Lansing, Michigan Database Administrator 5 We are looking for a team-oriented person with a deep understanding of database administration (SQL Server and Sybase) to help support MDOC. Above all we are looking for someone that is passionate about public service, building positive team culture,...
-
Senior Oracle Database Administrator
2 weeks ago
Lansing, United States Rose International Full time*Date Posted: * 04/18/2024 *Hiring Organization: * Rose International Position Number: 462583 *Job Title: * Senior Oracle Database Administrator Job Location: Lansing, MI, USA, 48915 Work Model: Hybrid Employment Type: Temporary Estimated Duration (In months): 13 Min Hourly Rate($): 65.00 Max Hourly Rate($): 66.00 Must Have Skills/Attributes:...
-
Oracle Database Administrator 5
2 days ago
Lansing, United States InterSources Full timeJob Title : Oracle Database Administrator 5 Location: Lansing, MI , Hybrid Rate : Best competitive rate Top Skills & Years of Experience: Oracle Database Administration (19c or higher) RAC (required) OEM Perform Patching and Updates Vulnerability Remediation Bachelor's degree required 10+ years experience Candidates MUST be able to speak to skills listed...
-
SQL Database Administrator
2 weeks ago
East Lansing, United States Creative Financial Staffing Full timeJob Title: Database Administrator Location: East Lansing, MI (Onsite) Job Type: Full-time, Permanent About the Company: A privately held organization in the financial industry located near the East Lansing, MI area is seeking a full-time, permanent Database Administrator to be an integral part of their Site Reliability team! Here are a few reasons why you...
-
Database Administrator
2 weeks ago
Lansing, United States Ageatia Global Solutions Full timeJob 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. This position is for an expected 40 hours per week Monday through Friday with two days on site (Wednesdays are a mandatory onsite day). There is currently a rotation for on...
-
Sr Oracle Database Admin
3 days ago
Lansing, United States Saxon Global Full timeProfile & Description Monitors the day-to-day activities of production and non-production database systems to ensure smooth operation of all environments. This includes space administration within the database and at the operating system level to ensure the database systems perform properly and without disruption. Additionally support performance tuning,...
-
Role: Database Administrator-- W2 Only
1 month ago
Lansing, United States TMS LLC Full timeJob DescriptionRole: Database AdministratorDuration: Long Term (W2 only)Location: 235 South Grand Ave., Lansing, Michigan 48933 (need nearby candidate within 50 to 60 miles) Work Arrangement: Hybrid 3 days office 2 days remote Experience: 10 + years Top Skills & Years of Experience:- Candidates must have experience with migration from Sybase to SQL...
-
LU - ASP.Net Developer -4-20
2 weeks ago
Lansing, United States Focused HR Solutions Full time $45 - $55PLEASE SEND RATES AND RESUME TO ZIPFHR@FHR-SOLUTIONS.COM Please send rates and resumes to ross@fhr-solutions.comCandidates will be allowed to work remotely during COVID. Once restrictions are lifted and the client’s office opens, candidates will be required to work 100% onsite daily M-F 8-5 pm in Lansing, MI, with NO exceptions Our direct client has an...
-
Systems Administrator
3 days ago
Lansing, United States Saxon Global Full timeTitle: Systems Administrator Description:The individual is responsible for overseeing the maintenance and security of the Michigan Department of Health and Human Services (MDHHS) Bureau of Laboratories (BOL) Bioinformatics and Sequencing Section local and cloud High-Performance Computing (HPC) systems. Their duties include installing antivirus or malware...
-
Programmer Analyst 4
5 days ago
Lansing, United States TekWissen LLC Full timeJob DescriptionJob DescriptionOverview: Tekwissen Group is a workforce management provider throughout the USA and many other countries in the world. The Client below runs through fifteen executive departments which carry out the day-to-day administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights,...
-
Programmer Analyst 4
4 days ago
Lansing, United States EGROVE SYSTEMS CORPORATION Full timeJob DescriptionJob DescriptionTitle: Programmer Analyst 4Location: Lansing, MI (Local, Onsite)Duration: 12 MonthsRate: $65/hr on C2CInterview: In-PersonExp: 8+ yrsAs a Salesforce Developer/Cloud Architect, you will be responsible to provide technical oversight for all new and existing SaaS implementations for the Agency Services Support team at the...
-
Programmer Analyst 4
6 days ago
Lansing, United States VeeRteq Solutions Inc. Full timeJob DescriptionJob DescriptionJob Title: Programmer Analyst 4 Location: Lansing, MI, 48917 Duration: 12 Months Job Type: Contract Work Type: Hybrid Job Description: As a Salesforce Developer/Cloud Architect, you will be responsible to provide technical oversight for all new and existing SaaS implementations for the Agency Services Support team at the...
-
SQL Server/Azure DB Administrator
3 weeks ago
Lansing, United States IO Datasphere Full time**If you are interested in this position:** Download the skills matrix using the button below and fill it out. Email us and attach the **completed skills form** and your **most recent resume** to us at: jobs@iodatasphere.com Please include '**7994MI Skills Form**' and your name in the subject line. Position SQL Server/Azure DB Administrator Location...
-
Business Analyst 4
2 weeks ago
Lansing, United States Novalink Solutions Full timeJob Description The Department of Technology, Management and Budget (DTMB) supports the business operations of state agencies through a variety of services, including Information Technology project delivery, maintenance, and support. This position is with Agency Services for MDOC and Assists in the design, development, delivery, and support of Information...
-
Professional Aide/ Administrative Assistant
2 days ago
East Lansing, United States Michigan State University Full timeJob postings Professional Aide/ Administrative Assistant Back to search results Apply now Job no: 944415 Work type: Extension, Support Staff Pay Grade:05 Major Administrative Unit / College:Michigan State University Extension Department:Extension Children And Youth 10058941 Sub Area:AP- Professionals Salary:18.00 per hour Location: East Lansing...
-
Programmer Analyst 4
2 days ago
Lansing, United States Idealforce Full timeIDEALFORCE has a CONTRACT position available immediately for a Programmer Analyst 4 - Salesforce Developer/Cloud Architect to join our customer in Lansing, MI. This is an hybrid position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Job Description As a...
-
Systems Administrator IV
7 days ago
Lansing, United States Volt Full timeVolt is Immediately Hiring for - Cloud Administrator - Remote (DC ) As Cloud Administrator - You will: Job Description : REQUIREMENTS (MUST HAVES): Security Clearance Required - PUBLIC TRUST Primary Responsibilities : * Administration & Governance * System administration tasks for both Linux and Windows server based systems including provisioning,...