Database Administrative
Location: Alpharetta, GA_Hybrid
Duration: 12+months
Pay range: $60-65/Hour on W2
Responsibilities
Requirements
- Expertise in Installation, Upgrade & Patching of different components in Oracle, Sybase, and experience with the other platforms we manage listed in the Duties and Responsibilities.
- Experience with Replication including setup, troubleshooting issues and failovers
- Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
- Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
- Provide data cleansing services, verify data integrity, and implement access controls
- Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
- Experience with Schema creation, deployment, and maintenance
- Experience with Setting up and configuration of Auditing, audit trails
- Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
- Should have knowledge of Disaster Recovery setup and maintenance
- Automation using shell-script, python, go, etc. Performance & Tuning Related Expertise
- Assist Developers and business analysts with their queries and tune them, if required
- Experience with Performance analysis, monitoring of SQL queries and platform specific tuning
Employee Benefits:
At LanceSoft, full-time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits:
- Four options of medical Insurance
- Dental and Vision Insurance
- 401k Contributions
- Critical Illness Insurance
- Voluntary Permanent Life Insurance
- Accident Insurance
- Other Employee Perks
EEO Employer
LanceSoft is a certified Minority Business Enterprise (MBE) and an equal-opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.
Thanks
Drishti
Lancesoft Inc.