SUMMARY:

• Over 8+ years of experience in Administration and Development on Database Design using SQL server 2005, 2008, 2012 Servers in OLAP and OLTP environment and also AWS, Azure environments.
• Experienced in other RDBMS (Oracle 10g, 11g and 12c)
• Excellent SQL Server administration skills including Database Creation, Tables, Indexes and Clusters Creation.
• Experienced in DBA activities include Installing & maintaining SQL Server database system, Logical/Physical database design and administration, Backup & Recovery, Log Shipping, Database Mirroring and Performance Tuning.
• Experience in implementing Full, Transaction Log and Differential backups.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients.
• Worked on Oracle Database in the development, testing and production environments.
• Supported teams in resolving SQL Server Reporting services and T - SQL related issues.
• Experience in SQL Server concepts SSIS (Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Implemented and deployed Azure offerings including both the IaaS and PaaS offering.
• Extensive use of dTs/SSIS packages in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC utilities.
• Installation, administration and maintenance of Oracle 11g
• Hands on implementation experience with a strong background in Azure Platform, Microsoft SharePoint and Microsoft Dynamics development, infrastructure, governance and content management
• Proficient in automating database backups through Oracle Linux shell scripts, excellent skills in upgrade, migration and applying quarterly patches.
• Upgraded and Migrated sQl Server Systems from SQL Server 2008 to SQL Server 2012.
• Experience in usage of DBCC commands and DMV’s for Performance Tuning.
• Good knowledge of database performance tuning using Profiler, Query Execution Plan and Database Engine Tuning Advisor.
• Created, configured, tested, and maintained Corepoint Integration Engine HL7 interfaces
• Experienced in developing and managing stored procedures, Triggers, Indexes, views, Data Transformation services and Locking.
• Experience on OLTP/OLAP environment (Analysis Services, Reporting Services and Integration Services).
• Implemented and provisioned AWS services combining hands on experience with services like EC2, Cloud Front, Cloud Formation templates and monitoring services like Cloud Watch etc.
• Expertise Security, Auditing and Compliance for the production and non-production databases.
• Proficient with sQl server Management Studio, Scheduling jobs with SQL server Agent and SQL Profiler.
• Excellent hands on experience, in web servers such as Apache Tomcat, IIS
• Experience working with very large databases (VLDBs) and troubleshooting the problems.
• Strong experience in performing database consistency checks and planning and Recovery procedures
• Experience in user Management activities like adding the user and managing the permissions.
• Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.
• Strong problem solving and analytical skills.
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure.
• Quick learner and good performer; work well independently and on a team
• Experience is providing 24X7 support and on call rotation schedule.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R2/2008, Oracle 10g/11g/12c, MS Office Access

Programming: HTML, XML, C++, Java, JavaScript

Applications: Microsoft Office, Microsoft Visio, Microsoft Publisher, Microsoft Project, Share Point, Setting up Log Shipping & using DTS (Data Transformation Service), Administration and Installing of MS SQL Server 2014, 2012, 2008, 2005

SQL Server: Management Studio, Business Intelligence Development Studio, Visual Studio 2008, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, SQL, T- SQL, DDL, DML, Stored Procedures, uDf, Triggers, DTS/SSIS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, Microsoft Clustering Services (MSCS).

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2010, Cognos 8.3/8.4, Power View

Data migration: MS DTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard.

Others: AWS, Windows Azure, ER-Win v 4.0, Visio 5.0, PL/SQL, Visual Source Safe, Net Backup, Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, ERWIN 4.0, Toad, SQL Plus.

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, NJ

SQL DBA

Responsibilities:

• Design and implement SSIS packages for loading data from various sources including custom parsers for HL7 XML.
• Assisted in migrating databases from one server to another with different collation settings.
• Relocation of databases from one server to another server using attach and detach databases.
• High Availability - Implement and support Log Shipping and Mirroring and supported several Disaster Recovery tests.
• Implemented procedures to import data from legacy systems to the current model using MS Access & MSSQL Server Import & Export wizard.
• Handled periodic database refreshes in QA-Test environment for testing of new Deployments and Build.
• Responsible for routine DBA jobs like Backups and Restores.
• Checking Database Health by using DBCC Commands and DMVs.
• Assisted in migration of the existing data center into the AWS environment.
• Provided Oracle network troubleshooting, technical and administrative duties Resolved complex database issues.
• Tested Private Cloud and bringing up Azure cloud stack in Lab.
• Design and Develop new SSAS Tabular models and provides operational support to existing SSAS Tabular models to satisfy business requirements.
• Effectively communicate the differences between Azure and on-site technologies and the benefits of each type of deployment.
• Managed servers on the Amazon Web Services (AWS) platform instances using Puppet, Chef Configuration management.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Research- Trying to best practice of the implementation and looking for all the possibility of moving SQL Servers into Azure cloud.
• Installed the application on AWS EC2 AMI, Red hat, Ubuntu Instances.
• Harden SQL Server Security by reducing the surface area so as to prevent the physical data being hacked from hackers and more proactive maintenance
• Participated in creating indexes to improve the performance of database and Created Constraints, Defaults and Views
• Worked heavily with BBDA (for server builds), Foglight (for monitoring), and LiteSpeed (for backup compression).
• Monitor Oracle Database jobs and backups
• Implemented AWS solutions using E2C, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.
• Developed MDX queries against SSAS Cubes to generate reports for analysis.

Confidential, Middletown, NJ

SQL DBA

Responsibilities:

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production.
• Involved in Migration of the Server SQL Server .
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Worked on High availability environment like Replication, Database Mirroring and Log Shipping.
• Extensively worked on Snapshot and Transactional Replication.
• Implemented the disaster recovery processes.
• Created Tomcat and Apache user groups.
• Responsible for transferring packages using SSIS.
• Created and modified Stored Procedures and Functions to generate reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilt the indexes Confidential regular intervals for better performance.
• Upgraded Apache and Tomcat in Production servers to latest version, configured and tested successfully.
• Day-to-day activities such as backups to the disk and restore the databases and transaction.
• Setup, implemented, and maintained industry standards in database management.
• Troubleshoot performance problems and fine-tuning of databases.
• Monitored SQL server performance using SQL Profiler to find performance and deadlocks.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Good Confidential Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Experience in working with MSSQL Server 2005 & 2008 on 32 and 64 bit environments.
• Involved in Migration of the data to MSSQL Server 2005 & 2008 engines from Microsoft Access using Import & Export Wizards.
• Expertise in ESM Reports using Discovery tool, which scans the MSSQL Servers/Machines/ Instances as configured, across various domains for various violations.
• Responsible for creating Constraints and Indexes.
• Created views to restrict access for the security of data in a table.
• Caught and Reported errors using exception handling.
• Monitored performance of the scheduled jobs and alerts.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Generated reports using SSRS.
• Used SSRS to create drill-down and drill-through reports.
• Scheduled jobs and alerts using SQL server agent.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to SQL Server 2008 by using SSIS. Involved in SSIS Package, Import/Export for transferring data.
• Maintained and supported databases ranging from 10Gb to 1Tb
• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Implemented Microsoft recommended patches and service packs
• Supported the release management by promoting new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008.
• Performed index analysis to enhance the response times of SQL statements and stored procedures
• Analyzing query performance using SQL Profiler and tuning queries which are running slow by using different methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Experience in Database security and integrity planning
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi­Production Servers and handling maintenance Jobs.
• Setup monitoring scripts on the server for sending alert notifications for any database or operating system issues
• Configured and maintained DR environments for various databases using Log Shipping and Mirroring
• Participated in planning meetings for the upcoming and existing projects
• Provide 24x7 on-call support for operations

Confidential, Morristown, NJ

SQL Developer

Responsibilities:

• Resolve data issues for Trouble Tickets, analyzing and making data modifications.
• Implementation of MS SQL Server Management studio to create Complex Stored Procedures using T- SQL to evaluate result for the reports & Developed different Scripts for the Data analysts for verification of reports.
• Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2008.
• Performance tuning of the SQL 2008 servers in order to reduce I/O and Memory contentions.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2008.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Highly experienced in designing and developing Workflow Management solutions using MQ Workflow.
• Working with CMA (Content Management Application) to facilitate database changes/SQL querying/ promoting packages to different testing environments.
• Extensive experience in providing 24/7 on call support for applications running on IBM WebSphere MQ/Message Broke and Application Server
• Understand/maintain the data model for the LOS application.
• Worked on Detailed design and unit test plans.