Database Analyst
Previous Job
Previous
Database Analyst
Ref No.: 18-23323
Location: Winfield Park, New Jersey
Position Type:Right to Hire
Start Date: 04/06/2018
Role : Database Analyst
Mode : Contract type - W2

Location: Iselin, NJ(South) | Winfield Park | Winfield Park, NJ
Competencies:Communication, PL/SQL, Database Optimization and Tuning, Database Administration (DBMS)

Role Description:
• Create complex SQL Queries for multiple projects
• Fine tune PL/SQL queries
• Take transition from Project teams and relay to offshore team.
• Share weekly and daily status reports with clients
• Knowledge transition
• Client communications

Desired Skill:
• Experience in working controlled environment, change control, and validated systems.
• Experience on Oracle RDBMS is plus
• Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.

Essential Skills:
• In-depth expertise with SQL
• Knowledge of testing STLC and testing basics
• Expertise in Database Testing.
• Strong Experience with SQL Server Clustering, Mirroring, Log Shipping, Always On
• Key Experience with SQL coding and tuning
• ETL and Informatica database experience
• Must be hands-on, technically adept DBA, capable of performing required DB tasks.
• 8+ years of SQL Server DBA experience
• Must be hands-on, technically adept DBA, capable of performing required DB tasks.
• Deep knowledge with SQL Server 2008+ databases
• Strong troubleshooting/performance tuning skills required. Must be able improve SQL performance.
• Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
• Ability to implement automation to reduce manual administrative tasks through use of jobs, shell scripts, PL/SQL or other techniques.
• Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.
• Experience with very complex database environments.