SUMMARY

• Over 7 years in depth experience in MS SQL Server 2008R2/2008/2005 as Database Administrator in Healthcare, Finance, Education & Retail Industry in Production, Testing and Development Environments.
• Proficient in MS SQL server installation, configuration and upgrade.
• Experience in Data Modeling, Conceptual, Logical and Physical database design.
• Developed complex stored procedures, processed large amounts of data in SQL queries using T - SQL.
• Intensive experience in Monitoring and Tuning and CLR integration in SQL Server, database and Query performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor and MDW.
• Implemented High Availability plans like Clustering, Log shipping & Database Mirroring.
• Experience using ETL tools like SSIS and automated teh collection of teh data from various Data Sources, Data cleansing and loading into Staging, ODS(other data sources) and Data warehouses.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database.
• Experience in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems.
• Experience and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large and Complex Databases.
• Implemented different types of Replication models like Snapshot, Merge and Transactional replication and monitored them.
• Create Reports using Microsoft Reporting Services (SSRS) and Crystal Reports.
• Performed Schema Management, Client/Server Connectivity, Database Rollouts, Load Testing, Load Balancing, Database consistency checks using DBCC Utilities.
• Experience in managing database maintenance plans such as backup database task; check database integrity task, Rebuild Index, Re-organize Index and update statistics.
• Create and maintain Databases, Tables, views, triggers, UDFs, stored procedures, schemas, indexes, statistics, creating logins and users, creating Roles and managing user permissions.
• Hands on experience on data transformation Services, Batch Processes, Import/Export, BCP (bulk copy procedure) tools.
• Support, monitor & Troubleshoots SSIS package(s) jobs on regular basis.
• Design & Implemented Data archival procedures and partitioning large tables and indexes.
• ExperienceinMigrating SQL Server 2005 to SQL Server 2008.
• Experience in Software Development Life Cycle (SDLC), SQL Server Memory Management, Incident Management, Change Management, Version Control VSS, OLTP, OLAP, DTC and fixing teh database corruption.
• Experience working withproduction and 24 x 7on call environments.
• Preparation and maintain SQL Server standard documentation (IQs and OQs).
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies and good team work skills and ability to think outside teh box.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2005/2008/2012, MS Access 2007/2010, MYSQL, Oracle10g

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008, Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, MS Visio, SSRS, SSIS, SSAS

Programming Languages: SQL, TSQL, XML, PL/SQL, VBA, VB6.0

Web Tools: MS-Front Page, Internet Information Server(IIS), FTP, TCP/IP, LAN, MS-Outlook

Operating Systems: Windows 8.1/7/XP/NT, MS-DOS, MS Windows Cluster Server 2003/2008, MS Windows Virtual Machines

Utility Tools: MS Office, MS Project, Clear Quest, Visual Source Safe 6.0, Advance Excel

Reporting Tools: SSRS, Crystal Reports, MS Access Reports

PROFESSIONAL EXPERIENCE

Confidential, Arlington, TX

SQL DBA/Developer

Responsibilities:

• Install, maintain and support CLR integration on SQL Server 2012 on Windows 2008 R2 Cluster environments and also worked as real-time support on SQL back end data extraction.
• Design Relational Database Model, implement and test as per business needs.
• Maintain Database autantication modes, create users, configure permissions and assign roles.
• Index Defragmentation byRebuild/Reorganizeof Indexes on aweeklybasis across all big size Databases.
• Install, configure, deploy and maintain security of SSIS and resolving issues dat come up.
• Created Jobs, Alerts,SQLMail Agent, and automating SSIS Packages.
• Resolve various application failures due to data entry errors or system errors, identifying problems and implementing corrective actions.
• Export and Import data, change and capture data from other data sources like flat files using SQL server Import/Export wizard and SSIS.
• Performed Query Optimization, Performance Tuning by using SQL Profiler and Index Tuning Wizards.
• Created Clustered / Non clustered Indexes on Tables to improve performance
• Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.
• Responsible for gathering requirements and designing data mart entities and data warehouse.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Develop complex mappings using expressions, aggregators and procedures to develop and feed Data warehouse.
• Set up full, differential and T-log backups as a routine operations and restore procedures during disaster period by giving administrative support to recover full database with a minimal data loss.
• Implemented several built-in excel functions and formulas, pivot tables and charts for summarizing data.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database.
• Development of automated notification on SQL Server Backups failure SQL back end data extraction and scheduled maintenance Jobs.
• Install, deployments, service accounts, add patches, perform upgrades & migrations, process job tickets & resolve bugs.

Environment: Microsoft SQL Server 2012, MS Windows Server 2003/2008, Visual Studio, T-SQL, SQL Profiler, MS Office, VBA.

Confidential, NYC, NY

Database Consultant

Responsibilities:

• Installation and configuration of SQL Server 2012 Enterprise Edition on 2 node Active cluster for production data.
• Dynamic configuration for memory and Configuring storage of data and log files and restore model for creating databases.
• Data modeling by Erwin6.0 and Microsoft Visio also use Visual source safe 6.0 for SQL scripting and rollback procedures.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database.
• Design & Implemented Data archival procedures and partitioning large tables and indexes.
• Tested teh ETL mappings from Source to Target.
• Written test cases for checking teh populated data correctly into fact and dimension tables and generate scripte using data compression.
• Used DMVs & Performance Monitor Counters to quickly find teh Root Cause of performance slow-downs.
• Create and maintain Databases, Tables, views, triggers, UDFs, stored procedures, schemas, indexes, statistics, creating logins and users, creating Roles and managing user permissions.
• Estimated space requirements for a database and Monitored Data files and Log files.
• Monitored Database Performance using SQL Profiler and system Performance Monitor.
• Tuned teh database to perform efficiently by managing databases using teh options to grow or shrink database files and monitor teh size of teh transaction log.
• Performed daily backup and created named backup devices to backup teh servers regularly.
• Performance tuning and optimization of Queries On SQL 2008/2012
• Migrated SQL 2008 databases to a 64 bit SQL 2012 platform.
• Enable data compression on SQL 2008.
• Implemented INSIGHT Data warehouse for budgeting and Financial Reporting.
• Played a major role in Upgrade of ACCPAC production application by SAGE.
• Design Database and Implement JohnGalt Forecasting System for teh company.
• Enhanced an existing Excel applications consisting of several VBA programs and macros.
• Created advanced formulas, user defined functions and formulaic arrays for data analysis.
• Worked withproduction and 24 x 7on call environments.

Environment: MS SQL Server 2012, Windows Server 2008, DTS, VSS, ERWIN, MS Visio, SharePoint, Accpac, Agile, MSDOS, EDI.

Confidential, Houston, TX

SQL DBA

Responsibilities:

• Assist in migration of MS Access Databases 2007 to SQL Server 2008 by using Import wizard and SSIS Packages in SQL Server.
• Install, configure, deploy and maintain security of SSIS and resolving issues dat come up.
• Ensuring data governance, capacity planning, and overall management of data entities consists of teh policies, processes, controls, and audit function of industry standards.
• Perform full Backups and transaction log backups. Restore them whenever necessary; create backup strategies and schedule them for execution.
• Advanced use of Pivot Tables and excel formulas including V-Lookup and H-Lookup on spreadsheet.
• Used SSRS, MS Access to create reports.
• Prepared test cases by understanding teh business requirements Data Mapping documents and technical specifications.
• Assist with UAT and functional testing for all teh Mappings and Sessions.
• RunDBCC consistency checks, and fixing data corruption in user databases.
• Actively involved inSQL Server Replicationfor copying and distributing data and database objects from one database to another and tansynchronizing between databases to maintain consistency.
• Export and Import data, change and capture data from other data sources like flat files using SQL server Import/Export wizard and SSIS.
• Query optimizationand increasing teh performance of Stored Procedures (SP) by looking into theexecution plan, Indexes, Outdated Statistics.
• Installation of Service Packs, patches and Hot fixes and also created teh documentation for tracking and installation purposes.
• Set up full, differential and T-log backups as a routine operations and restore procedures to recover full database with a minimal data loss.
• Scheduling SQL Server Agent Tasks to periodically running of tasks.
• Provided 24x7 production supports.

Environment: SQL Server 2005/2008, Windows Server 2003, Enterprise Manager, SSIS,SSAS, SSRS, Query Analyzer, Crystal Report, MS Excel, VBA, MS Access, VB6.0, Scrum (sprint), SharePoint.

Confidential, NYC, NY

SQL Developer/DBA

Responsibilities:

• Implemented SQL security for application users using Active Directory; Maintained Database autantication modes, creation of users, configuring permissions and assigning roles to users.
• Involved in Stored Procedures (SP) Tuning and Performance and Query tuning Activities.
• Administrate and managing of SQL server Agent jobs across teh enterprise.
• Trouble shooting of dump & load failed jobs on Production & DR servers.
• Resolved issues related to database performance, database capacity, replication and migration.
• Troubleshoot connectivity issues, monitor performance and tune in complex multi or three-tier architectures; Query optimizationand increasing teh performance of store procedures by looking into theexecution plan & Indexes.
• Using SQL Profiler and Tuning Queries to improve performance and used Index tuning Wizard.
• Troubleshoot SQL issues by using SQL Tools, execution plans, Trace & statistics.
• Data extractions and Reports generation modules are written for management use.
• Extended teh capabilities of an existing database used to track customer records in pure & refined way after applying different queries.
• Created reports using Sql Reporting Services & crystal reports.
• Created documentation for future time and training to new onboard users.

Environment: SQL Server 2005, Windows Server 2003, Enterprise Manager, SSIS,SSAS, SSRS, Crystal Report, ERWIN, Oracle, Query Analyzer.

Confidential, Jersey City, NJ

SQL DBA

Responsibilities:

• Createdmaintenance plan for teh performance of SQL Server Covers databaseIntegrity Checks, Update Database Statistics and Indexing, CreatedClustered and Non Clustered Indexes on tables, views, and columns.
• Performed Database consistency checks with DBCC, Defrag and monitored error logs.
• Planned teh Complete Backing up of Database and Restoring teh Database.
• Involved in designing of Complex database (Physical and Logical database Design).
• Designed ETL process to import/reformat data to a relational database design to correct issues and improve performance.
• Created a Pivot report in Excel for company management to summarize Treasury functions. Used Access to get teh data and push it down to Excel.
• Troubleshoot and maintain existing MS Access database for Company’s Data Inventory System Department.
• Data Validation in MS Excel 2007, created forms for data entry while using data validation.
• Assist teh team in teh implementation of SQL Server 2005 for POS reconciliation for teh Treasury Department. Used SSIS to facilitate moving data from teh previous Microsoft Access based system to a fully functional SQL Server solution.
• Monitored Databases for Dead Lock, Capturing long runningSQLqueries, used HINTS for fine-tuning SQLstatements dat better result in efficientSQLstatements processing.
• Process large amounts of data in SQL queries.
• Created a custom data backup program for teh Treasury Department.

Environment: Windows 2003 Server, MS SQL Server 2005, TSQL, DTS, SQL Profiler, MS Office, Visual basic 6.0.