SUMMARY

• 8+ Years of experience as an IT professional in SQL Server Database Administration, Designing, System Analysis, Develop and Implement solutions on SQL 2014/2012/2008 R 2/2008/2005/2000 in Production, Development & Testing Environments.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in standalone and cluster environments.
• Expertise in upgrading (In - place Upgrades) and migrating databases from MS SQL Server R2/2012 and SQL Server .
• Extensive subject matter expertise in IT Services Management (ITSM)&ITIL, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.
• Expert level knowledge in Server Consolidation and Data Center migrations.
• Expertise in Performance Tuning/ Query tuning, identifying and tuning SQL Server Hardware bottlenecks.
• Experience in monitoring performance using various SQL server inbuilt tools like Performance Monitor, SQL Profiler, Event Viewer, DMV’s/DMF’s
• Execution plans, Index tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries etc.
• Extensive experience with database administration, advanced data recovery, data corruption, capacity planning, extended SQL Server Internals& Server Memory and RDBMS concepts.
• Experience in supporting Very Large (VLDB) high transactive databases and troubleshooting their performance bottle necks with SQL Server Profiler and PerfMon.
• Expert in creating various SQL server objects: Tables, Indexes, Indexed Views, Stored Procedures (Dynamic and Static), Functions and Triggers to facilitate efficient Data Manipulation and Data Consistency.
• Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
• Expert in working with Third party backup tool like SQL Lite Speed, Idera SQL Safe for monitoring production environments, resolve bottlenecks &improve Performance of the application.
• Experience with Disaster Recovery Setup like SQL Clustering (active/active, active/passive), SQL Replication, Mirroring, Log Shipping, HADR, Always ON, Availability groups.
• Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries
• Capacity planning, Monitoring Tempdb, Cleanup tasks, Disaster recovery solution maintenance etc.
• Experience in applying SQL Server database service packs, hot fixes and security patches.
• Extensive experience in handling security issues, maintaining Database Authentication Modes, Creation of Users, Configuring Permissions and Assignment of user roles as per enterprise policy.
• Created a Virtual Network on Windows Azure to connect all the servers.
• SSIS - Extract, Transform and Load data from various heterogeneous data sources like Access, Excel, CSV, Oracle, Flat File and Text Format Data, Teradata using OLE DB connection by creating various SSIS packages.
• Experience in working with Normalization and Demoralization databases for reducing redundancies and dependencies.
• Excellent knowledge in creating custom specific and schedule reports using SQL Server Reporting Services (SSRS).
• Expertise in creating drill down reports, parameterized reports and Ad-Hoc reports using SSRS (2008R2/2008/2005).
• Experience on TDP (Tivoli Data Protection) and SNAP Manager for creating database backups and restores.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Involved in migration of databases from Sybase / Oracle to SQL server.
• Experience in designing, creating, processing of Cubes using SSAS and using MDX Queries.
• Built a prototype Azure application that accesses 3rd party data services via Web Services.
• The solution dynamically scales, automatically adding/removing cloud based compute, storage and network resources based upon changing workloads.
• Experience in creating SQL Batches using T-SQL and deploying batches for database upgrades.
• Experience in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions).
• Having experience on SAN and RAID levels and building SQL cluster servers on SAN Environments
• Worked with the version control tools like Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS)
• Developed scripts for database monitoring and tuning procedures.
• Conversant with full SDLC involving System Analysis, Design, Development and Implementation.
• Ability to work in team environment with excellent communication, presentation, leadership. Analytical, qualitative and interpersonal skills.
• Proven abilities in establishing effective task priorities, working independently and participating as an integral part of a team.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MDS, Enterprise Manager, Query Analyzer, Performance Monitor, Database / Index Tuning Wizard, DBCC, Data Transformation Services, SQL Profiler, BCP, Event Viewer.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Import/Export Wizard.

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, MySQL, Oracle, MS Access.

Other Tools: Microsoft Visual Source Safe, IDERA, Lite-speed, RedGate, Spot lite, Sentry, Visual Studio, Report Builder, Crystal Reports, MS Excel, Visio, Erwin, TFS.

Languages: SQL, T-SQL, PL/SQL, C#, HTML, XML, ASP.NET, JavaScript.

Operating Systems: Windows 2003/2008/2012, Windows 98/NT/2000/XP/Vista/7, VMware, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, Washington

Sr. SQL Server DBA / Developer

Responsibilities:

• Installation, configuration of SQL Server 2008R2/2012 Enterprise Edition in Production & other lower environments. Applied latest service packs and windows patches.
• Responsible for Critical server support 500 servers out of which 150 servers are production servers, remaining Prod like, test and development servers.
• CreatedETLSSISpackages both design and code to process data to target databases. Created document for Self-Service Deployment and Execution process forSSISpackages.
• Create and edit alerts on Reports, as per User request
• Involved in writing MDX queries for various calculated members
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts MS SQL.
• Create, manage SQL Server AZURE Databases.
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.
• Developed an Azure based high performance compute environment to support the massive computational requirements of client congressional redistricting Azure application
• Developed a conical map/reduce-like architectural pattern that that is designed to leverage the Azure platform.
• To manage and handle very large sized databases, size of each is about 3TB in production, development and Test environment.
• Regular checkup of automated daily, weekly and monthly maintenance tasks such as backups, update statistics, consistency checks and rebuild indexing.
• Created Logins, Users and assign permissions based on the level of database access the user would need.
• Experience in deploying SQL Batches for database upgrades for every quarter releases.
• Analyze, document and present all related security, architectural, and operational requirements applicable to develop possible solution sets.
• Involved in Data modeling, designing, and building relational databases.
• Created and designed data models using Erwin data modeling tool.
• To fine tune queries for betterment of SQL performance we use DBCC commands, DMV’s and DMF’s.
• Monitoring and Performance tuning, Physical Server Level, Database level (Database settings and options) and query tuning.
• Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.
• To perform capacity planning and database sizing for production servers.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment
• Handled multiple SQL instances on cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Involved in ensuring data recovery, maintenance and data integrity and space requirements for physical database.
• Expert in Idera and Scom Monitoring and writing T/SQL scripts.
• Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose.
• Configuring Database Mail Service in MSSQL 2012/2008 for SQL Agent Job Notifications.
• Creating, Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Working with XML, SQL queries, SSIS, web services, import/export data validation.
• Deploying and troubleshooting SSIS/DTS packages with a multitude of Data sources and complex data conversion logics.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes, Functions, Stored Procedures and referential integrity depending on user requirements and converting them into technical specifications.
• Monitor the database systems to ensure secure services with minimum downtime (SQL Server 2008/2012).
• Provide 24/7 support for critical situations& Database support in On Call rotation.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Migrated database from Sybase ASE 15.7 to SQL server 2012.
• Recreated views and stored procedures for Sybase server
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring, SQL Server clustering& configured Snapshot and Transaction Replication.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity Issues and backend performance issues.
• Performed Defragmentation Techniques for most complex indexes.
• Expertise in working with ITIL processes including change, problem and incident management.

Environment: SQL Server 2012/2008R2/2008/2005, MS Access, SSIS 2008, SSRS 2008,VB Scripting, DB2, Oracle 9i/10g, Visual Studio 2005, VBA, XML, XSLT

Confidential, Gainesville, FL

SQL DBA / Developer

Responsibilities:

• Install, Configured SQL Server, 2008, 2008R2, 2005 Enterprise & Standard editions on 64 bit systems.
• Excellent report creation skills using Microsoft SQL Server 2012 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Assisted and closely worked with Architect team in setting up code standards, performing code reviews, evaluating additional resources to the existing/New applications.
• Installed and Configured SQL Clustering (2node Active-Active) for Mission critical applications
• Configured Log Shipping/Mirroring to support adhoc reporting, Configured and Maintained SQL Server Replication(Snapshot, Transactional, Merge) to support the core application functionalities.
• Experience on TDP (Tivoli Data Protection) and SNAP Manager for creating database backups and restores.
• Experience in creating SQL Batch files to execute Data Manipulation Language (DML), DDL statements against databases.
• Installed SQL server instance on VMware.
• Installing/ Configuring PostgreSQL from source or packages on Linux machines
• Database administration, maintenance, and schema design for PostgreSQL and MS SQL Server.
• Responsible for maintaining the reporting, billing, and invoicing databases (PostgreSQL) (about 125 databases on three servers).
• Database administration, maintenance, and schema design for PostgreSQL and MS SQL Server.
• Installed, Upgraded and maintained Oracle, MS SQL Server and Postgres databases.
• Experienced in creating instance/Database level SQL Auditing and Change Data Capture.
• Used CDC (Change data capture), Table valued parameters and other new features in new applications.
• Configure/Maintain Backups using Litespeed in various environments supporting their needs.
• Used various SQL inbuilt tools like SQL Profiler/Perfmon/Execution plans and 3rd party tools like Confio Ignite, Idera, Redgate to track issues, identify bottlenecks and implementing solutions.
• Worked extensively on Performance tuning, Code tuning, Query optimization, Identifying hardware bottlenecks and allocating required resources etc.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Worked closely with software development team, Change control team, Development/QA/UAT teams ensuring the full integration and smooth functioning of the database portion of the environment.
• Designed and configured SQL Security with help of AD Groups, SQL Roles for users, applications and assigning appropriate permissions to the databases.
• Implemented enterprise level functionalities like Database Partitioning on Analytical systems for better performance.
• Worked with co DBA’s to install strong proactive monitoring jobs to monitor the environments and generate the reports on daily basis.
• Scheduled maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries
• Capacity planning, Monitoring Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
• Designed the Backup-Recovery plans to minimize data loss and faster recovery
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Chart diagrams.
• Created different reports based on the requirements, and retrieve data using stored procedures that accept parameters using SSRS.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Expertise in Installing, configuring SSIS, SSRS, SSAS, deploying SSIS packages, reports and configuring Cubes and dimensions and trouble shoot the issues and identifying the root causes etc.
• Creating database on AZURE and setting up SQL AZURE Firewall, Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
• Upgrade all the existing SQL Serversdatabase Servers to SQL server 2008 and scale out on demand to the cloud (Azure).
• Production database support (24*7*365) on all versions.
• Experience on complete software development life cycle (SDLC) with software development models like Agile Scrum Model, JIRA, Prototype model & RUP, Waterfall model.

Environment: SQL Server 2008R2/2008/2005, MS Access, SSIS, SSRS, SSAS, Lite-Speed, Ignite, ETL, .ASP, Oracle 10g/11g, Windows 2008/2003.

Confidential, Richardson, TX

MS-SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment.
• Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems.
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Designed and implemented complex SSIS package to extract data from multiple data sources for analyzer.
• Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse.
• Designed and Developed Complex SSIS packages using SQL SERVER 2008 Integration Services, OLEDB, file system task, ftp task in SQL SERVER Integration Services to upload and download the ETL DATA.
• Designed and implemented database changes.
• Evaluating data modeling, database administration, database backup and recovery tools and make recommendations
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Used SSRS to report exceptions and data analysis reports.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, MS-Office, Access, DTS, T-SQL

Confidential

SQL Server DBA

Responsibilities:

• SQL Server 2005 Database Administration.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Develop and implement replication, archiving and backup and recovery strategies.
• Hands on experience with Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions and Process Documentation.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Evaluated data storage considerations to store databases and transaction logs, shrinking the Transaction logs.
• Restoration process testing from the backup server- by this we makes a note of timing user to restore the archive files. This is done once a month to make sure the entire archive files for consistency.
• Automated the Jobs responsible for the Daily backups of the System and Users Databases, Indexing, Fixing the Work Flow, Integrity check, Security Permissions
• Shrinking Databases and created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, insufficient disk space and security breach.
• 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.
• 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 in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in generating various reports using the SQL Server Reporting Services.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Wrote numerous stored procedures to perform data cleaning/loading task once data is loaded into staging area.
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.

Environment: Windows 2000/2003, MS SQL Server 2005/2000, T-SQL, MS Access, SSRS, Replication, Active/Passive Clusters