What are the responsibilities and job description for the Database Analyst position at mPower Software Services?
JOB DESCRIPTION
Candidates shall provide the appropriate LOE technical expertise to support the client program.
Responsibilities Include:
- Install new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements
- Provide technical support to development staff
- Support basic IT issues such as password resets, peripheral configurations, hardware diagnostics, and coordinate repairs
- Perform hardware buildouts
- Perform daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media and media is recycled
- Repair and recover from hardware or software failures and communicate with impacted constituencies
- Plan and respond to service outages including backups and restores
- Assist configure networking services and protocols
- Installation and configuration of Oracle databases, patches and associated products
- Basic monitoring and tuning - troubleshoot potential database performance bottlenecks and find solutions
- Database security - administer and recommend mitigation
- Create job as and or stored procedures using command of SQL, PL/SQL & GUIs
- Write raw SQL to interact with databases
- Other duties as required
Qualifications
- Bachelor’s degree (in computer science, engineering, mathematics, or related field) 10 yrs. related experience
- Familiarization with AWS Database Services (RDS, Aurora) and PostgreSQL database installation/administration
- Must have a solid understanding of fundamental network design and operation
- Familiar with the Oracle DBMS bundles that extend Oracle DB functionality
- Strong command of SQL tools
- PL/SQL knowledge and ability to read scripts written by programmers and fine-tune queries
- Strong knowledge and experience with Red Hat software suite (Red Hat 5 and above)
- Experience working with HP, Dell and Cisco products
- Knowledge working with HP Openview, Loadrunner, VMWare, Rational software, Oracle, DOORS, SQL, Linux, Unix, and Java
- Knowledge of system vulnerabilities and security issues
- Must be able to take direction from others
- Must have good communication skills
- Ability to work efficiently individually or in a team environment
- Ability to travel when needed
- Good at problem solving
- Ability to multi-task
Job Types: Full-time, Contract
Pay: $80,000.00 - $120,000.00 per year
Benefits:
- 401(k)
- Life insurance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Education:
- Bachelor's (Required)
Experience:
- SQL: 5 years (Required)
Ability to Commute:
- Egg Harbor Township, NJ 08234 (Required)
Ability to Relocate:
- Egg Harbor Township, NJ 08234: Relocate before starting work (Required)
Work Location: In person
Salary : $80,000 - $120,000