SUMMARY

• 8+ years of experience in Database Administration and Development for very large and complex databases in SQL Server 2014, SQL Server 2008 R2, 2008 and 2005.
• Administering SQL Server High Availability and Disaster Recovery strategies including Always - On Availability Groups (AAG) and HA/DR Troubleshooting.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Hands on experience in DR processes including Log Shipping and Database Mirroring.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience on Data center servers and handling very large databases (VLDB).
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g.
• Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS).
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008/R2, 2005, Oracle 10g, 11g R2, MySQL

Programming: C, C++, Java, .NET, SQL, PowerShell Scripting

DBA: Database administration of MS SQL Server 2014, 2012,2008, 2005

Operating system: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

BI: SSIS, SSRS, SSAS, Oracle BI

Tools: Red Gate SQL Backup, SQL LiteSpeed, Visio, Zendesk, Erwin, IDERA

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Cloud: AWS & AZURE

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Database Administrator

Responsibilities:

• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding/Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2014/2012/2008 R2 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Team Foundation Server, Microsoft Reporting Services.

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.

Environment: SQL Server 2012/2008/R2, Oracle 10g/9i, .Net Framework 2.0, C#.Net, Asp.Net 2.0, JavaScript, VSS, Windows 2008R2, Windows 2003 Server, MS TFS, MS-Access.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 databases to SQL Server 2008.
• Recovering the databases from backup in disasters.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• Creating and Maintaining Database Maintenance Plans for nightly/weekly backups.
• Developed custom T-SQL Scripts for database maintenance jobs including database consistency check, index defragmentation.

Environment: SQL Server 2008/R2/2005, Windows 2008/2003 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler, MS TFS.

Confidential

Jr Database Developer

Responsibilities:

• Filtered bad data from legacy system using complex T - SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House from various different sources including Flat Files and Excel Sheets.
• Used VB. Net and C# code in Script Task and Script Component.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created and Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Environment: SQL Server 2008//2005, Windows 2003/2000 Server, .Net, SSIS, SSRS, MS TFS