SUMMARY:

Results - oriented, highly productive technical professional with over 14 years of success in applying strong problem solving skills to clarify ambiguity and resolve highly complex issues within the tightest timeframes. Act as a key member of the team influencing a clear vision for success with an aptitude to establish goals. Expert DBA with the proven ability to synthesize complex information and liaise between technical teams and business stakeholders. Efficiently handle implementation, integration, backup and restore database designs, perform data exports imports. Foster an atmosphere of teamwork and collaboration with an emphasis on goal attainment.

AREAS OF EXPERTISE:

• Effective Communications
• Customer Service & Support
• Team Leadership & Adaptability
• Cross-Group Collaborations
• Project Management
• Database Administration
• System Implementation,Migration & Upgrade
• SDLC Best Practices
• Quality Assurance
• Systems Security
• BCP & DR
• Problem Solving/Troubleshooting
• Critical Thinking
• Performance Improvement

TECHNICAL SKILLS:

Operating Systems: HP-Unix 11.x, Unix, Windows 2008/2012 Server

Databases & Tools: Oracle Database 9-11g, Oracle Application Server (iAS) 10g, OEM, SQL Server 2008 & 2012Oracle 12c RAC & Dataguard.

Active/Passive: Clustering, SSMS, T-SQL, Toad, Microsoft Developer, MS Office, Visio, Project

Programming: PL/SQL, Unix Shell Scripting, Windows Power Shell, Oracle AS 10g Forms and Reports

PROFESSIONAL BACKGROUND:

Confidential, NORTH BERGEN, NJ

DBA

Responsibilities:

• Work closely and regularly with Management, Developers, Business Analysts, QA and Infrastructure Teams, and updating with regular reports and status updates. Databases of ERP, JDE, JDA, Retail POS (Micros, Epicor), PeopleSoft, Hyperion, Warehouse Management Systems, Demand & Supply Chain.
• Install, configure, administer and tune Oracle 9i, 10g, and 11g databases & Oracle Application Server 10g.
• Write and maintain generalized scripts to create databases, get definition of the existing databases, to monitor and maintain databases and their alert log files, listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts, export and import scripts on HP UX environment.
• Develop Unix Shell scripts for different database monitoring tasks.
• Setup and maintain documentation as standards for future usage.
• Deploy and maintain database environments development, QA, integration, production source, data integrity.
• Ensure all PCI and SOX compliance requirements are met.
• Provide 24/7 support to client databases, deliver on-call and on-demand support.
• Perform backup and restore of SQL Server databases and applications.
• Install and configure SQL Server 2008/2012, create schemas, logins, tables, clustered and non-clustered indexes, views, functions and stored procedures.
• Perform general database administration, query performance tuning and validate existing schemas.
• Administer SQL Server security and maintain security requirements across environments.
• Manage users by assigning appropriate permissions, monitor and schedule jobs and alerts.
• Serve on Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Provide primary support on Oracle Databases & Application Servers and Secondary support on MS SQL server Databases & Applications.
• Directed database migration from 9i to 10g releases and applied latest patch sets.
• Facilitated server upgrade from SQL server 2008 to SQL server 2012, installed service packs.
• Involved in a 36-hours nonstop Data Recovery and helped successfully recover data.

Confidential, NORTH BERGEN, NJ

SENIOR APPLICATION DESIGNER & DEVELOPER

Responsibilities:

• Developed, tuned and debugged queries, reports, triggers and stored procedures in SQL & PL/SQL.
• Created and maintained Oracle 10g Forms and Reports.
• Analyzed, manipulated, and investigated data problems, analyzed data requirements used in the creation of system reports utilizing integrated report-writing tools.
• Researched migration and continuous application improvement strategies.
• Solely maintained and upgraded the POS application.

Confidential, NORTH BERGEN, NJ

JUNIOR DBA

Responsibilities:

• Drove daily performance tuning initiatives and troubleshot assignments, including AWR reports, checking alert logs and trace files.
• Administered Oracle software installation, upgrade and patching.
• Configured, deployed, and administered vendor and in-house applications interfacing with Oracle.
• Managed and maintained application system, created users and monitored current requests.
• Cloned UAT and Development databases.
• Took over the source code deployment for Development, QA, and Production environment.

Confidential, NORTH BERGEN, NJ

QA ANALYST

Responsibilities:

• Performed both automated and manual testing utilizing testing tools such as WinRunner, Test Director, Toad to test. Created functional test plans for SEWN (demand & supply chain application) and WMS (Warehouse Management Systems).
• Wrote and executed SQL and PL/SQL queries for analysis, research, enhancements and validation of data integrity.
• Managed Mexx integration projects along with offshore (Mexx Europe) IT group. Created, tested and tracked data integrity between Mexx and Liz Distribution Logistics application.
• Performed analysis, created test plans, executed test scripts, functional and integration testing in WMS.
• Supported Mexx Europe Distribution team in writing test plans, and executing of test scripts.
• Worked closely with internal and external vendors, developers and teams across the organization, participated in document and deliverable reviews, software revisions, change requests, assessments, provided feedback, and followed up with internal and external clients.
• Ensured deployment of defect-free RFCs and production fixes by analyzing test results, identifying and regressing anomalies/bugs.
• Skillfully maintained all computer configurations and application compatibility on workstations in the QA Lab.
• Analyzed business requirements and functional design specifications.
• Wrote and executed SQL queries to ensure data integrity that met business requirements.
• Developed Schema files in XML format to be used in Microsoft Access Stringing Utility.
• Utilized the concept of Functions, Libraries and Packages used in Oracle to create coherent functions, libraries and packages in WinRunner for SEWN automated scripts that increased productivity.

Confidential, NORTH BERGEN, NJ

APPLICATION SUPPORT SPECIALIST

Responsibilities:

• Liaised between developers, vendors, DBA’s, network administrators to support, troubleshoot SEWN & WMS.
• Assisted LIZ’s Distribution Centers to meet receiving and shipping deadlines by resolving trouble tickets in a timely manner. Determined LIZ business process and created a reference guide.
• Skillfully communicated with internal & external clients to get production issues resolved in a timely manner.