SUMMARY

• 7+ years of experience in Database Administration, design and programming using SQL Server 2014/2012/2008 R2/2008/2005, Oracle 10g.
• Experience in Implementing SQL Server Clustering (Active - Active, Active-Passive), Multi Node cluster.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008R2 to MS SQL Server 2012 from 2008R2 server to 2012R2 Server.
• Experience in different industry sectors like Banking/Finance, Insurance, Telecommunication, Airlines, Health Care and Retail.
• Experience in Transparent Data Encryption to encrypt an entire database for Security and Backup encryption using SQL Server 2008.
• Expertise in DBCC Trace Flags and Blocking situations, Indexing for large tables in SQL Server.
• Exposure to Water fall and Agile methodologies in Software Development Life Cycle (SDLC).
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Strong experience in analyzing Business Requirements, Functional and Technical Specification.
• Experience in active directory with SQL Server Powershell Extensions.
• Good knowledge on working and executing SQL queries for Backend testing.
• Implemented the concepts like Data partitioning, snap shop isolation, Database snapshot, try-cache blocks, indexing, and dedicated administration connection.
• Master in performing Administrative tasks, Database files Management, Backup/Restore, Security Management, Database Mirroring, Data Integration and Synchronization, application design, Isolation Levels and managing server and clients.
• Experienced in database design, Relational Integrity Constraints, OLAP, OLTP, and Normalization of transactional database schema and legacy systems.
• Experience in database Database Maintenance Plans to keep indexes and statistics updated.
• Experience on High Availability SQL Server solutions and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Configured SMTP server for Database mail setup and received alerts for the threshold values.
• Monitoring Jobs, Alerts and scheduling SQL server Agent jobs.
• Expertise in SQL Server Business Intelligence Development Studio in creating SSIS packages and SSRS reports.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Very Large and Complex Databases.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full - text indexing, and Database Application Development using varied development tools.
• Extensively worked on SSIS in SQL Server, Performance Tuning & Application Design, Hot and Cold Backups, Disaster Recovery Planning, Managing server and clients, T-SQL, PL/SQL, Stored Procedures, Functions, Cursors, Triggers, Packages, SSIS, Data Transformation Services (DTS) Packages and SSAS etc.
• Excellent analytical, problem-solving, coding, analytical and communication skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, C#

Development Environment: Enterprise Manager, SQL Server Profiler, Query Analyzer, Export & Import

Database: MS SQL Server 2012/2008R2/2008/2005, MS Access, Oracle 11g/10g/9i/8i/7.x

Operating System: Windows Server 2008R2, Windows Server 2012R2, Windows Server 2003, Windows 7/XP/2000/NT/98, VistaReporting Tools SSRS, Crystal Reports 9/8.5

Database Tools: SQL Server Management Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer, SSAS,SSIS, DTS, Resource governor, Replication, Business Intelligence Development Studio (BIDS), Red Gate, Ideara Diagnostic Manager

ETL Tools: SSIS 2008R2/2008/2005, DTS, BCP (Bulk Copy Program)

Designing Tools: Erwin, MS Visio, ProClarity

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

MS SQL Server DBA

Responsibilities:

• Responsible to manage and maintain Databases for 24x7 High Availability and Disaster Recovery for thousands of customers.
• Responsible for Installing and configuring SQL Server 2008R2 on Windows 2008R2 and 2012R2 servers.
• Worked with the team to develop and modify PowerShell Scripts to optimize work.
• Optimized queries using Performance Tuning and Index Tuning.
• Migrating Databases from 2008R2 servers to 2012R2 servers with no to minimal customer downtime.
• Worked with customer to troubleshoot problems and optimized workflow as per their need.
• Create Alerts as per the business requirements and fix problems upon alert generation.
• Formulate plans to maintain Regular Database Backups and restore strategies for Disaster Recovery.
• Monitored and maintained Database Mirrors for High Availability.
• Maintained LogShipping for Disaster Recovery plan
• Generate extensive reports on servers’ capacities and move databases as per business requirements.
• Export data in flat files and Excel from servers for regular monitoring and historical data collection.
• Generate production data to check and maintain it within threshold values.
• Isolating and migrating production data of customers from one database to another as required by the SLA.
• Updating security fixes for all SQL Servers. Updating or removing servers outside of security compliance.
• Performed the database backups for both production, and Test environments.

Environment: MS SQL Server 2008R2/2012/2014, Windows Server 2008R2/2012R2, SSRS, PowerShell

Confidential, Birmingham, AL

MS SQL Server DBA

Responsibilities:

• Responsible for Installing and configuring SQL Server 2008 and 2012 on Windows 2003 and 2008 servers.
• Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.
• Extensive use of DBCC commands to investigate the Database issue and formulate the remediation.
• Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Server for SSRS.
• Implement migration SQL Server databases, DTS packages from one server to another.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created standard operation procedures (SOP) for initial database shell creations for specific customer package builds.
• Developed the metrics and trending processes for SQL database sizing and growth.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Involved in upgrading from SQL Server 2008 to SQL Server 2012 including all SSIS and SSRS packages.
• Performed the database backups for production, test and development environments.
• Created the backup and restore strategy for the all three environments.
• Worked with the Database optimization, Performance tuning and index tuning for optimization of queries.

Environment: MS SQL Server 2008/2005, Windows Server 2008/2003,Virtualization, Ideara Diagnostic Manager, RedGate, SSIS, SSRS.

Confidential, Fort Worth, TX

MS SQL Server DBA

Responsibilities:

• Installed and configured MS SQL Server 2005, 2008 and 2008 R2 on Windows Server 2008 R2 SP1, 2008 and 2005. Also applied service packs and security fixes on these servers.
• Responsible for Installing, configuring and maintaining SQL Fail over clustering for two production environments.
• Responsible for a large scale of database migration from SQL server 2005 to SQL server 2008 and 2008 R2.
• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Involved in database and log backups and restoration, planning backup strategies, and scheduling.
• Backing up master & system databases and restoring them when necessary.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Created Indexes, Views, complex Stored Procedures, user defined functions, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Involved in creating Logical & Physical Database Design using data modeling tool Erwin.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this databases on requests.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Using third party tool Idera, monitor all the servers and their jobs in a single Management Console.
• Working with creation, installation and configuration of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.
• Working with DTS package to import and export operations in and out of the SQL Servers.
• Scheduling jobs and alerts using SQL Server Agent. Administrating Confidential Operation Manager (MOM) 2005 in an existing IT infrastructure.

Environment: MS SQL Server 2008 R2/2008/2005, Windows Server 2008 R2/2003, SQL Server Reporting Services 2008 (SSRS), SQL Server Integration Services 2008(SSIS), Confidential Visual Studio, SSMS, MS Excel, T-SQL, Erwin.

Confidential, San Antonio, TX

SQL Server DBA

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 and provided documentation.
• Helped development team with point in time database recoveries.
• Responsible for 24x7availability of production databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Responsible for creating reports based on the business requirements using SSRS 2008
• Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
• Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin 7.2

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008 (SSRS), SQL Server Integration Services 2008(SSIS), VSS, Confidential Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, Erwin.

Confidential, Baltimore, MD

SQL Server Developer/ SQL Server DBA

Responsibilities:

• Responsible for maintaining SQL Server Database for High Availability.
• Responsible to maintain Backups of all Databases for Disaster Recovery.
• Building and re-building indexes to optimize the database performance.
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2003.
• Created ad-hoc, parameterized, drill down and cascaded parameterized reports in SSRS 2005.
• Uploaded SQL Server 2000 Reporting Services (SSRS) RDL files to SQL Server 2005.
• Migrated and modified all DTS packages to SQL Server Integration Services (SSIS) accordingly using its SSIS advanced features.
• Extracted data from Oracle and migrated data from various sources (text based files, Excel spreadsheets, and Access) into SQL Server 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005.
• Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Services.
• Helped developers to write queries by extensively using Joins and Sub-Queries to simplify complex queries involving multiple tables and worked with database objects like Tables, views and indexes.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Responsible for transferring packages using SSIS on to production Server.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005,MS SQL Server Integration Services, Excel, Acrobat Reader.

Confidential, Irving, TX

SQL Server Developer/ SQL Server DBA

Responsibilities:

• Involved in Planning, Defining and Designing Database based on business requirements.
• Responsible to maintain the availability of Databases close to 100%.
• Maintain security of database by maintaining the user-profile and granting and revoking accesses.
• Used SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Identified and worked with multi-valued parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly, also scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports, MS Visual Studio 2005, MS Office, SQL Profiler