- Lansing, MI
- Candidates must have experience with migration from Sybase to SQL Server (23 years minimum experience with Sybase and SQL)
- Candidates must be experienced in troubleshooting.
- Unix/Solaris experience
- 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.
-
Sales Representative
10 hours ago
SYSCO Lansing, United States Full timeCompany: · US0068 Sysco Grand Rapids, LLCZip Code: · 49512Minimum Years of Experience: · 0-1 YearsEmployment Type: · Full TimeTravel Percentage: · Up to 25%COMPENSATION INFORMATION: · The pay range provided is not indicative of Sysco's actual pay range but is merely algorithmic ...
-
Associate, Part Time Sales
2 days ago
Sleep Number Lansing, United States Part timeCompany Overview · Sleep Number team members are part of a passionate, purpose-driven culture that supports improving the health and wellbeing of society through higher quality sleep. We are not just focused on our customers, however; being employed by Sleep Number means your per ...
-
Licensed Practical Nurse
2 days ago
Regency at Lansing West Lansing, United States Full timeWant to make a difference in someone's life every day? As a licensed practical nurse (LPN) with Regency at Lansing West you will work as part of a team providing skilled nursing and short-term rehabilitation care to our valued guests. If you have patience, compassion and a desire ...
-
Certified Nursing Assistant
2 days ago
Regency at Lansing West Lansing, United States Full timeFull Time Day shift · Want to make a difference in someone's life? · If you have patience, empathy and a true desire to care for those in need, you will love working as a Certified Nursing Assistant (CNA) at Regency at Lansing West In this role, you have an opportunity to leave ...
-
Nurse Practitioner or Physician Assistant
2 days ago
MRG Exams East Lansing, United States Full timeWork can be performed by a Nurse Practitioner or Physician Assistant · We are looking for the right Nurse Practitioner or Physician Assistant to perform medical assessments on United States Veterans as part of the VA's disability benefits process. · In performing Disability Asses ...
-
Clinical Laboratory Technician
2 days ago
Actalent Lansing, United States Full timeDescription: · Details: Aseptic slide scraping, automated whole blood and plasma DNA extractions · Performs analyses on blood, tissue, and body fluids to aid health care providers in the diagnosis, prognosis, and treatment of patients. Testing is performed in specialized laborato ...
-
Nurse Practitioner or Physician Assistant
2 days ago
MRG Exams Lansing, United States Full timeWork can be performed by a Nurse Practitioner or Physician Assistant · We are looking for the right Nurse Practitioner or Physician Assistant to perform medical assessments on United States Veterans as part of the VA's disability benefits process. · In performing Disability Asses ...
-
Registered Nurse
4 days ago
Regency at Lansing West Lansing, United States Full timeAre you a critical thinker, a skilled communicator and passionate about caring for seniors? Are you seeking career advancement? As a Registered Nurse (RN) at Regency at Lansing West, you have the opportunity to use your nursing skills and become a leader. · At Ciena Healthcare, w ...
-
Cook
4 days ago
Regency at Lansing West Lansing, United States Full timeDo you enjoy preparing delicious meals? Are you compassionate and have a longing to serve individuals who may struggle with health and physical limitations? Would you like to foster your passion for the culinary arts? · If you are interested in joining a team that recognizes your ...
-
Nurse Practitioner or Physician Assistant
1 week ago
MRG Exams East Lansing, United States Full timeWork can be performed by a Nurse Practitioner or Physician Assistant · We are looking for the right Nurse Practitioner or Physician Assistant to perform medical assessments on United States Veterans as part of the VA's disability benefits process. · In performing Disability Asses ...
-
Nurse Practitioner or Physician Assistant
1 week ago
MRG Exams Lansing, United States Full timeWork can be performed by a Nurse Practitioner or Physician Assistant · We are looking for the right Nurse Practitioner or Physician Assistant to perform medical assessments on United States Veterans as part of the VA's disability benefits process. · In performing Disability Asses ...
-
Store Associate
7 hours ago
CVS Health Michigan City, United StatesCashiering · Stocking · Customer Service · Cleaning of the store · Open Availability from 8am-11pm needed · Starting pay is $15/hour · **Job Types**: Part-time, Seasonal, Temporary · Pay: $15.00 per hour · Shift: · - 4 hour shift · - 8 hour shift · - Evening shift · Weekly day ra ...
-
Behavior Consultant
7 hours ago
New Beginnings Behavior Intervention Services Michigan City, United States**About us** · New Beginnings BIS is a Medicaid waiver provider through Indiana's Home and Community Services Waiver. We are hiring independent contractors to provide Behavior Management services to individuals with intellectual and developmental disabilities. We are professional ...
-
Elementary Principal
7 hours ago
Michigan City Area Schools Michigan City, United StatesEducation Required Level: _Master's Degree · **General Purpose**: · The Principal is central to the viability of a school. Michigan City Area Schools is looking for an instructional leader who will be able to build on the work of current faculty and administration. · **Main Job T ...
-
Head Boys Basketball Coach
7 hours ago
Michigan City Area Schools Michigan City, United StatesAssignment Category:_ _ECA_ · **General Purpose**: · Michigan City High School is seeking a Head Varsity Boys Basketball Coach for the season. The Head Coach is a key individual within the athletic program and the community of Michigan City. The Head Coach is responsible for the ...
-
School Social Worker
7 hours ago
Omni Therapeutics, Inc. Lansing, United StatesOMNI THERAPEUTICS INC. has been providing school-based health and therapy services to the suburbs of Chicago since 1982. We are a small family-based company of approximately 40 IEP specialists. Joining our company offers applicants a unique opportunity to experience personalized ...
-
Housekeeping Team Leader
1 day ago
Beachwalk Vacation Rentals Michigan City, United StatesModeled after the "Truman Show" movie location - Work with us at Beachwalk Resort & Vacation Rentals · Join our team and be a part of the summer long beach party Beachwalk Resort & Vacation Rentals in Michigan City, Indiana and New Buffalo, Michigan is seeking reliable and enthus ...
-
Elderly Caregiver
1 day ago
ComForcare Home Services Michigan City, United States**Job description** · **Job Duties Include**:_Conversation & Companionship · - Meal Preparation · - Light Housekeeping · - Errand Services · - Grocery Shopping · - Laundry *Bathing, Dressing & Grooming Assistance · - Transferring & Positioning Assistance · - Medication Reminders* ...
-
Cashier - Receptionist
1 day ago
Aston Martin of Chicago Lansing, United StatesThe Ed Napleton Automotive Group is looking for our next **Cashier Receptionist**. This is an exciting opportunity in a growing, fast-paced industry. · The Ed Napleton Automotive Group is affiliated with over 25 brands of new vehicles and 50+ dealerships throughout eight states. ...
-
Daytime Janitor
2 days ago
Performance Plus Michigan City, United StatesDaytime Janitor · **Payrate: $15.00 per hour** · **Schedule: Days, M-F (7am-3:30pm)** · **Essential Functions** · - trash removal · - dusting · - cleaning restrooms · - re-stocking supplies · - sweeping · - mopping floors · - vacuuming · - window & sill cleaning · - replacing lig ...
Lansing, MI - Syntricate Technologies
Description
Role:
Database Administrator 4
Location :
Duration Months
Job Description
Top Skills & Years of Experience:
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: