SUMMARY:

• Over SIX years of experience in reputed IT organization having strong skills in SQL Server Administration and Information Analyst.
• Having very good exposure in AlwaysON technology and automated maintenance plan according to type of server.
• Experienced in working in collaborative team environment with other developers, business analysts, and a project management team.
• Extensive knowledge of maintaining SQL authenticated and Windows authenticated logins/users and grant proper privilege.
• Strong experience in capacity planning, implementing backup and recovery strategy for application and database.
• Expertise in implementing Database Mirroring in SQL Server 2012 and 2014 for high availability.
• Expert in implementing Log Shipping Technique used for warm standby solution for MS SQL Server databases.
• Experience in implementing Snapshot and Transactional replication models.
• Experienced in implementing TDE (Transparent Data Encryption) to secure data at rest and document the process.
• Extensive experience in MS SQL Server Business Intelligence.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon Counters and Spotlight.
• Extensive knowledge of configuring Database mail in SQL Server 2012 and 2008.
• Good Knowledge of SQL Server Dynamic Management Views as well as third party tools like Spotlights, Diagnostic.
• Experienced in logical and physical database design and development, normalization, data modeling and SQL server Enterprise Manager/SQL Server Management Studio.
• Expert in using tools like MS SQL Profiler, Index tuning wizard, Windows performance for monitoring and tuning SQL server performance.
• Extensive experience in using T - SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience in implementing the new features of MS SQL Server 2008 such as Policy Based Management, Backup Compression and Transparent Data Encryption.
• Knowledge of new features in SQL server 2012.
• Experience working with 24x7 Production support for 2012, 2008R2, 2008, 2005 and 2000 SQL Server.

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2014/2012/2008/2005

Databases Tools: SQL Server Management Studio, SQL Profiler, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio.

Programming Languages: T-SQL, C#, ASP.NET, Active Records, HTML and CSS

Web Tools: FTP, TCP/IP, LAN, MS-Outlook Express

Operating Systems: Windows 2003/2008/2012

Utility Tools: MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Chevy Chase, MD

SQL Server DBA

Responsibilities:

• Involved in installation of SQL Server 2012 and SQL Server 2014 in newer environments.
• Installed and Applied patches to the existing SQL servers and Upgrading SQL servers.
• Installed SQL Server Active-Active and Active-Passive clusters.
• Configured SQL Server jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts.
• Ensured regular database backups and recommend the appropriate recovery models for the production databases as per the database usage.
• Setup SQL Server Disaster Recovery.
• Automated weekly and monthly non-production database refreshes.
• Involved in providing SQL DBA Production support and Management.
• Configured High Availability practices like Log Shipping, Database Mirroring and Replication.
• Set up database snapshots on the secondary mirror database for reporting purpose.
• Responsible for maintaining SQL Server security and granting access to users as per requirement.
• Optimized SQL Server long running stored procedures and queries.
• Built SSIS packages to extract, transform and load DBA metrics data to monitor the database growth, huge tables and wait stats.
• Performed SQL Server Performance Tuning and optimization.
• Performed SQL Server database sizing, partitioning and archiving/purging.
• Developed SSRS reports on the DBA metrics data.
• Worked closely with developers to fix the performance issues during production hours.
• Maintained and up to date inventory of the SQL Servers.

Confidential, Seattle, WA

MS SQL DBA

Responsibilities:

• Performed business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Involved in Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferred the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server Reporting Services.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Monitored 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 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.
• Prepared the project management and technical documentation.
• Involved in Unit Testing the SSIS packages with respect to its flow and performance issues.
• Involved in Solving the Bugs Reflected by the Testing team.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Involved in Managing the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Completed documentation about the database. Recovering the databases from backup in disasters.
• Involved in exporting or importing data from other data sources like flat files using Import/Export through DTS, SSIS.
• Involved in analyzing long running slow queries and tuning the same to optimize application and system performance.
• Set up SQL Server configuration settings for better server management.
• Involved in monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Confidential

SQL DBA

Responsibilities:

• Worked with the project team, with the application domain experts to establish achievable deliverables from requirements provided.
• Worked with the project team to identify/clarify project goals, establish useful milestones, and developed a breakdown of the engineering tasks to be performed.
• Performed Database analysis, design and troubleshooting.
• Optimized the Views, Queries and Stored Procedures to enhance the Reports Performance. Created indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.
• Created the new ODBC connection for viewing and connecting the Crystal Reports X1 to the newer databases.
• Created new SSRS Reports in Visual Studio 2008 with enhanced layout and modifications.
• Used Import /Export Wizard to transfer the data from Excel file to table.
• Optimized the Reports performance by checking the Execution Plan and SQL Server Profiler.
• Used Query optimization techniques wherever possible to enhance the reports performance.
• Wrote stored procedures and functions to simplify the logics in the Reporting services. Added parameters in the reports to filter data effectively.
• Developed Sub Reports, Matrix Reports and Tabular, Charts, Drill down, Drill through and Parameterized reports using SQL Server Reporting Services (SSRS).
• Successfully deployed the reports on the Report Manager.