Database Administrator / Database Developer Resume Rutherford, NJ - Hire IT People

SUMMARY:

Have 3+ years of professional experience as Database Admin /Developer.
Extensive experience in Data modeling and T - SQL.
Experience in creating master detail forms, adding Alerts and deploying the forms on web.
Skilled in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
Proficient in RDBMS concepts and worked with MySQL 5.0, Oracle 9i/10g and SQL Server.
Proficient in SQL, PL/SQL, Oracle Server, HTML, CSS, JS
Hands on Experience in Amazon Web Services.
Excellent communication and problem solving skills.

TECHNICAL SKILLS:

Database: ORACLE, SQL SERVER, Dynamo DB, MONGO DB

Languages: Java, JDBC, C, C ++, UNIX SHELL SCRIPTS

Web Technologies: HTML, JavaScript, AJAX, CSS, Angular JS, Bootstrap.

Tools/ IDEs: Eclipse IDE, NETBEANS, VISUAL STUDIO, SQL NAVIGATOR, OPEN REFINE.

Operating System: Windows, IOS, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Rutherford, NJ

Database Administrator / Database Developer

Responsibilities:

Worked with Business Analyst and System Analyst in gathering business requirements and specifications from different stakeholders.
Extract, Transform and Load (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
Created new tables, written stored procedures for developers and some user defined functions.
Monitoring remote client backups for remote shares.
Resolving client and internal database issues quickly and at minimum downtime.
Identifying bottlenecks that are stopping databases from working properly.
Responsible for performance tuning and application tuning.
Communicate team progress and dependencies with other team leads during scrum meetings.

Tools: SQL Server, SQL server monitor.

Confidential, Rutherford, NJ

Database Administrator / Database Developer

Responsibilities:

Designing, debugging, and optimizing T-SQL queries, stored procedures, functions, views and dynamic queries for SQL Server.
Setting up database structures and queries to the precise requirements of clients.
Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
Scheduling the snapshots, maintaining snapshot history and creating subscriptions in report server.

Tools: SQL Server, Sybase

Confidential, Newark, NJ

Database Programmer

Responsibilities:

Tools: Dynamo DB, Alexa

Confidential

Database Manager

Responsibilities:

Maintain database stability, performance, and resiliency by setting and enforcing proper standards and controls.
Keep senior technical management informed by preparing reports on system performance and problems.
Upgrade hardware and software by assessing transaction processing and database production options.
Secure database by developing policies, procedures, and controls.

Tools: SOX, Oracle server, Microsoft SQL Server.

Confidential

Database Manager

Responsibilities:

Develop, test, and maintain huge DBs.
Troubleshoot and monitor all the DBs continuously.
Deploying bug fixes in a timely manner & in a way that causes minimum disruption.
Working closely with project managers, business analysts, data architects and DBAs.

Tools: Mongo DB, Eclipse, Visual Studio.

Confidential

Junior Database Developer

Responsibilities:

Creating and maintaining database objects such as tables, views, constraints, indexed, and stored procedures.
Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
Application testing and debugging on application Beta version.
Provided troubleshooting assistance to all issues and concerns related to forms.

Tools: UNIX, MySQL, ECLIPSE, DEBUG.