TECHNICAL SKILLS:

Operating Systems: Windows Server, Linux, UNIX

Databases: MS SQL Server 2014, 2012, 2008, 2008R2, Oracle, MS Office Access

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

Applications: Microsoft Office, Microsoft Visio, Microsoft Publisher, Microsoft Project, Share Point, DTS (Data Transformation Service).

SQL Server Technologies: Management Studio, BIDS, Visual Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, SQL, T - SQL, DDL, DML, Stored Procedures, UDF, Triggers, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, Microsoft Clustering Services (MSCS).

Report Tools: MS Reporting Services (SSRS), Crystal reports.

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

Others: Visio, PL/SQL, Visual Source Safe, Net Backup, Compaq Insight Manager, NetIQ, Quest Spotlight, SQL Light speed, ERWIN, Toad, SQL*Plus.

WORK EXPERIENCE:

Confidential, Jersey City, NJ

Responsibilities:

• Responsible of Production support of SQL server databases using SQL 2012/2014 on Windows environment.
• Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, and Resource Utilization.
• Responsible for SQL installations, test, deploy SQL instances, configure SQL native backups, restore databases and transaction log on production servers as per business needs.
• Configured different types of replication like Snapshot Replication, Transact replication from Multiple publishers to one subscriber and one subscriber to multiple publishers.
• Created Jobs and scheduled them for execution on Daily, Weekly, and Monthly bases.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server databases.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked on Dynamic SQL Scripts to fix orphaned users, database backups, dropping temp tables etc.
• Performance tuning and testing on stored procedures, indexes, and triggers using Database Engine tuning advisor and SQL Server Profiler.
• Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.
• Expert in implementing the snapshot isolation and DDL triggers.
• Track database changes using Data Auditing, and Policy-based management system.
• Ensuring Data Consistency in the Database through DBCC commands. Good knowledge in handling the Error Logs, Server space, health of Database and Servers.
• Monitored and audited enterprise data management activities including operational monitoring, daily ETL monitoring, report distribution, and performance tuning.
• Experienced in developing, maintaining and deploying complex SSIS packages. Implemented ETL for large datasets.
• Performed reporting services using SSRS web services interface for supporting and developing of customized reporting applications.
• Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization
• Performed database migration from SQL Server 2012 to 2014
• Deployed SSIS packages & SSRS reports and migrated data from MS Access, MS Excel and text files to SQL Server.
• Monitoring SQL server performance using SQL Profiler for performance issues & dead locks.
• Executed Change management scripts on weekly basis.
• Responsible for implementation and release of database changes according to agreed timelines and schedule.

MS SQL DBA

Confidential, Jersey City, NJ

Responsibilities:

• Installed, configured, administered and secured SQL Server 2012/2014 on production and non-production in Clustered and Stand-alone Server Environments.
• Responsible for providing 24X7 on call production support on weekly rotation to Production, Development, Testing, and Clustered servers.
• Day-to-Day tasks involved handling User permissions, monitoring Blocking, Deadlocks, long running jobs, and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Moved databases from on premise servers to Microsoft Cloud platform (SQL Azure) as part of application migrations.
• Implemented the restores of SQL Azure databases with a clear understanding of the backup retention periods of the Azure databases as per their service tiers.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Managed alerts, security, reorganized Indexes, and performed DBCC checks.
• Understood the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies & adding aggregations to OLAP Cubes.
• Involved in loading the partner flat files into the OLTP database. Developed T-SQL stored procedures to process these data and populate them in the appropriate destination tables.
• Monitoring and tuning report performance by analyzing execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Involved in Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database.
• Used SSIS tool to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
• Involved in trouble shooting & fine-tuning of databases for its performance & concurrency.
• Used DMV Dynamic Management View for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs.
• Production to UAT and Development DB Refreshes based on user requirements.
• Involved in root cause analysis and provided solutions for various recurring production issues.

SQL DBA

Confidential, Worcester, MA

Responsibilities:

• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Intensively worked on SQL Server 2012 and configured around 65 servers which includes a fresh install and in place upgrade from 2008.
• Migration of database objects between DBs and involved in monitoring SQL Server clustering.
• Exported & imported data from text files to SQL Server using bulk insert & BCP utility.
• Involved in troubleshooting dead lock issues and performance issues for optimal performance. Used the Index tuning wizard and rebuilt indexes for faster query response.
• Setup redundant servers to avoid one-point failures using EMC DMX technology "Cloning" and SQLDatabase Mirroring for highly active servers.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Investigated data missing issues and helped Development team in finding the bugs in code.
• Install, configure and maintain clustering to provide server high availability solution for multiple different environments.
• Involve in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Developed T-SQL proprietary extension to SQL used in interact with relational Databases.
• Setting up Full and T-log backups for all databases as a DR procedure for recovering the databases from backup in disasters and implementing Point-In-Time Recovery solutions.
• Developed Admin tasks of SQL Server of performing daily Backups & Recovery procedures.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve data from the Flat files on monthly and weekly basis.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Maintained security related activities such as logins and database object permissions for more than 75 users.
• Resolved security issues by creating new roles and granting required permissions to the users at various levels.

SQL Server DBA/Developer

Confidential, Denver, CO

Responsibilities:

• Migrated data from different sources including flat files, MS Access, Oracle to SQL Server 2008 by using SSIS. Installed multiple clients and resolved 32/64-bit driver issues.
• Planned and worked on setting up Table Partitioning for faster maintenance such as rebuild and update statistics.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages.
• Scheduling backups (full, differential backups and transaction-log backups) and automating maintenance tasks (Re-indexing, update statistics) by setting up SQL Server Agent jobs.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Performance tuning and testing stored procedures, indexes, and triggers using Index Tuning Wizard and SQL Server Profiler.
• Handled lot of production issues like data correction and resolves error handling
• Involved in configuring table/data partitioning on huge tables for better performance.
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Monitoring clients' application and escalating code bugs to development team. Supports Production, UAT, and Development Environment.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Ensure high quality code through rigorous code review processes.

SQL Developer/DBA

Confidential, Bentonville, AR

Responsibilities:

• Active participation in the business requirement meetings with the client
• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined Functions.
• Created Confidential Packages for transferring data from sources like Oracle, MS Access, and Excel.
• Created Confidential Packages to pull data from Oracle and Flat files.
• Handling database objects with Enterprise Manager and Query Analyzer.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non-Clustered Indexes on tables, views, and columns
• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading
• Configured Server for sending automatic mails to the respective people when a Confidential process failure or success.
• Performed data conversions from flat files into a normalized database structure.
• Generated reports by using Crystal Reports and Excel spreadsheets
• Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
• Analyzing Database Growth and Space Requirements. Handling Users, Logins or User Rights.