SUMMARY:

• Over 10 years of experience in SQL Server Technologies such as SQL Server Database Engine, SSIS, SSRS, SSAS.
• Major Skills are
• Administration of SQL Server Database Engine.
• Developing and Deploying SSIS Packages.
• Developing and Deploying SSRS Reports.
• Administration of SSRS and SSIS Servers
• Writing T - SQL Code which is performance efficient as well as meets proper standards.
• Expertise in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered Environment.
• Perform proper configuration of the database engine such as Max Server Memory, Data file paths, Proper TempDB configuration.
• Expert Level of understanding on Internal Database Files Architecture and good knowledge on Filegroups.
• Expertise in Installation, Configuration and Deployment of SSRS servers.
• Deploying SSRS reports in a performance efficient manner by utilizing Report Snapshots and Report caching. Managing and creating Report data driven subscriptions and Report security.
• Deploying reports in such a way as to improve performance by enabling Caching and Snapshots.
• Expertise in Database Maintenance Plans such as Backups, Index Rebuilds, Stats Updates and Consistence Checks.
• Strong knowledge in Performance tuning, Optimization, Data integrity.
• Installation of SSIS Servers and Proper Deployment of SSIS Packages.
• Good knowledge on working on the Windows Azure platform.
• Proficient in scheduling Backups and Restore, Maintenance plans using Native & Third-party tools.
• Experience in Scheduling and Automating Database tasks - Jobs, Alerts, Emails, Notification.
• Expertise in Change Data Capture (CDC) technology, its implementation along with CDC monitoring.
• Expert level understanding of managing and mitigating SQL Server Security vulnerabilities (Surface Level Attacks, SQL Injection).
• Deep understanding of SQL Server security offerings such as Logins, DB Users and encryption.
• Good understanding of SQL Server encryption components such as Service Master Key (SMK), Database Master Keys (DMK), Transparent Data Encryption (TDE) and SYMETRIC KEYS.
• Expertise in Database Performance Tuning.
• Expertise in SQL Server DMVs and Meta Data views of SQL Server
• Deep understanding of internal Index architecture (B-Tree) and Index Fragmentation and Fill Factor along with creating appropriate Indexes for queries.
• Expertise in T-SQL coding equipped with knowledge to write Performance efficient code along with best practices.
• Deep understanding of Statistics and Query Plan Analysis.
• Deep understating of Wait Statistics and to analyze the Wait Stats to resolve performance issues.
• Deep understating in SQL Server Internal Architecture and Transaction Log Mechanism.
• Expertise in monitoring technologies such as SQL Trace and Extended events.
• Deep understanding of the new extended events engine and its internal Meta data and effectively create Extended Event Sessions with proper predicates so as to facilitate for Short Circuit evaluation to reduce load on regular work load of the system.
• Expert level understanding of Tempdb behavior and proper configuration of Tempdb files to avoid PAGELATCH contention on allocation map pages of Tempdb.
• Good understanding of new features in SQL Server 2014 such as In Memory tables and Clustered Column Store Indexes.
• Through understanding of Configuring and Maintaining Database Mirroring and Database Snapshots.
• Deep understanding with Administration and Implementation of Active/Passive clusters.
• Good understanding with Implementation and Administration Always ON Availability Groups.
• Implementation knowledge of Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional Replication in SQL Server 2000/2005/2008/2008 R2/2012.
• Deep understanding of Backups (Full, Differential and Log) and Restores.
• Extensive experience in T-SQL coding and a good understanding of complex JOINS and advanced SQL features such as Window functions and Ranking functions.
• Good amount experience coding with XML features in T-SQL such as FOR XML, XQUERY and XPATH.
• Equipped with knowledge to write Performance efficient code along with best practices.
• Extensive experience developing SSIS packages. Good understanding of Data Flow Task and Data Flow Conversions. Equipped with knowledge to write performance efficient packages.
• Extensive experience developing SSRS reports.
• Comprehension of SDLC life cycle for Design, Development and Staging phases of the projects.
• Good knowledge in OOP’s concepts and Business Objects
• Working knowledge of .Net Framework 2.0/3.5(C#, ASP.Net, ADO.Net).

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Lead SQL Server DBA/Developer

Responsibilities:

• Responsible for maintaining Database builds and tuning the Database Management System in both test as well as production environments for SQL Server 2012 and 2008 R2 instances.
• Used TFS extensively to maintain and deploy database builds.
• Prepared instruction set for step by step build deployment in Pre-Prod and Prod Environments.
• Maintained database security for test, Pre-Prod and Production environments.
• Configured HA and DR for all the environments including Production Environment.
• Designed and implemented Backups and Restore database policies.
• Implemented and Administration of Active/Passive clusters in production.
• Implemented Always ON in several environments.
• Implemented CDC to capture all the DML changes. Maintained all the CDC data by creating all the CDC tables to more manageable file groups and monitored the CDC process for any Performance bottlenecks and took necessary actions to resolve.
• Worked extensively on improving the application performance from the database side.
• Tuned a lot of Stored Procedures for performance. Created necessary Indexes for the better performance of queries. Deployed a lot of Performance related reports by making use of DMVs (TOP Expensive Procedures, Duplicate Indexes, Unused Indexes .etc...)
• Made use of the new Extended Events feature for Monitoring Performance and Auditing the SQL Server.
• Designed Indexing strategy and suggested dropping and creating new indexes by analyzing the workload.
• Analyzed wait stats and determined the IO issues and took necessary actions to resolve those issues.
• Made extensive use of DMVs and other performance tools to tune the server.
• Designed a policy to monitor the wait types in SQL Server for trending analysis and predict the sql server health.
• Implemented horizontal table partitioning by creating partition functions and partition schemes.
• Responsible for creating and modifying tables, stored procedures, views, indexes, user-defined functions, and triggers etc. as required.
• Developed a lot of stored procedures and functions (Table Valued, Scalar) as per the functional requirements. Developed SQL queries as per standards along with ensuring that they are performance efficient. Incorporated a lot of advanced SQL functionality like Window Functions and Ranking Functions.
• Implemented Transactional Replication for replicating data to read only environment for reporting purposes.
• Administration and implementation of SSRS servers.
• Deployments and Management of SSRS reports along with management of report security. Configured SSRS report snapshots, report caching and managing report subscriptions.
• Developed SSRS reports myself and validated the reports developed by team members before deployment. Deployed a lot of Application Performance related and Business related Reports using SSRS.
• Administration and implementation of SSIS servers. Management of SSIS servers and deployment of SSIS packages in both msdb and file store and Scheduling SSIS jobs (SQL Agent).
• Developed SSIS packages myself and validated the packages developed by team members before deployment. Deployed a lot of Application Performance related and Business related packages.
• Involved in installations, upgrades, patches and fixes for SQL Server and related technologies.
• Responsible for monitoring and troubleshooting SQL Server jobs and SQL Agent issues in Production, Pre Prod and development environments.
• Lead a team of 3 Jr. DBAs.
• Involved in Health Check process for database.

Environment: SQL Server 2012/2008 R2, Windows Server 2012/2008 R2, Biz Talk Server 2004, T-SQL, SSIS and SSRS.

Confidential, IN

Sr. SQL Server DBA

Responsibilities:

• Involved in implementing and setup of the Data warehouse Environment for the client "Ingersoll Rand".
• Environment consisted of Database Servers, Reporting Servers and SSAS Servers and SSIS Servers.
• Built the environments in order to meet the company’s standards as well as best practices to address performance and security issues.
• Implemented Maintenance Plans such as backups (Full, Tlog, and Differential), Index Rebuilds, and Consistency Checks.
• Implemented a custom Performance monitoring setup of the SQL Server environments using Extended Events.
• Implemented the Migration of databases from local servers (Windows 2008 R2) to the new Windows Azure servers on the cloud.
• Involved in upgrading from databases from SQL Server 2008 R2 to SQL Server 2012.
• Implemented and Administration of Active/Passive clusters for the Data ware house.
• Implemented and maintained SQL Server Security by provisioning Logins, DB Users and custom roles.
• Implemented Transparent Data Encryption (TDE) in order to secure files and databases backups on disk.
• Involved in capacity planning and disaster recovery design strategy.
• Responsible for monitoring and troubleshooting SQL Server jobs and SQL Agent issues in Production, Pre Prod and development environments.
• Tuned a lot of Stored Procedures for performance. Created necessary Indexes for the better performance of queries.

Environment: SQL Server 2012/2008 R2, Windows Azure, Windows Server 2012/2008 R2, T-SQL, SSIS and SSRS, SSAS.

Confidential - Palo Alto, CA

Lead SQL Server DBA/Developer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005 & 2008 & 2012in development, test, and production environment
• Responsible for maintaining about 40+ servers.
• Installed and Configured SQL Server 2008 for testing different features and stability
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005
• Installed and Configured Operating Systems, Windows Server (2003 & 2008)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications (Snapshot)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server in testing and production environment
• Upgraded MS Access 2000/97 databases into MS SQL Server 2005, and 2008
• Applied SP’s (Service Pack) on SQL Server 2005, 2008
• Applied Patch on Windows Server 2003/2008 Enterprise Edition
• Strong on database Performance tuning
• Responsible for writing T-SQL and Stored-Procedures
• Used DBCC commands for maintaining the databases.
• Implemented and managed SQL Azure database for cloud servers
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Created, modified tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Backward & Forward Engineering with data modeling tools mentioned above
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SLQ Server
• Generated Reports using SSRS (SQL Server Reporting Services) in Excel, html, and text.
• Strong knowledge and working experience in Database Backup & Restore
• Responsible for Point-in-Time Recovery of backups (Full, differential and Logs).
• Responsible for capacity planning and disaster recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Developed Power shell scripts to monitor multiple servers (including application servers).
• Monitored Server Activity, and solved problem as needed
• Monitored SQL Server Error Log, space usage

Environment: SQL Server 2012/2008/2005, Windows 2003/2008 Advanced Servers, XML, SFTP, NDM, and IIS

Confidential - Dallas, TX

Sr. SQL Server DBA/Developer

Responsibilities:

• Responsible for monitoring and supporting 24X7 for 180 distributed servers (SQL Server 2008/2005/2000 ) on regular basis for20 TB databases.
• Leading teams of 5-10 people in size, help and mentor DBAs and managing the MS SQL Server teams
• Providing On-Call rotation with 24X7 Support
• Responsible for database administration and support in MS SQL Server environments
• Administered MS SQL Servers by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Involved in creating Databases, Tables, Clustered/Non-Clustered Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions and Defaults
• Performed Database integrity Checks, updated Database Statistics and performed re-indexing on a daily basis
• Interact with various departments for new release and troubleshooting of applications
• Responsible for migration and support of databases for Production, Integration and Development environments
• Working on Clustered environment and Log Shipping, Replication, DB Mirroring, SSIS & SSRS
• Providing 24 x 7 Production support for the database and application issues.
• Responsible for migration and support of databases for Production, Integration and Development environments (Change Management System).
• Experience in working with Data Modeling
• Working on Clustered environment and Log Shipping, DB Mirroring, SSIS
• Responsible for Implementation of Production, Integration and Development environment, Hardware requirements and support
• In migration process involved into Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Responsible for creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), Bulk Loading of Data through BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Worked with BRP (Business recovery plans) and capacity planning (number of boxes, amount of space, memory, rate of database growth).

Environment: SQL Server 2008/2005,SQL Server 2000, Windows 2003/2008 Advanced Servers, VB.Net, XML, BMC, VERITAS Storage Foundation VSF, Netbackup, SFTP, NDM, IIS, CMIS.

Medtronic - Mounds View, MN

SQL Server DBA / Developer

Responsibilities:

• Responsible for the installing MS SQL Server2005/2008, configuration, doing performance tuning, capacity planning and query optimization.
• Created and maintained various databases for Production, and Stage Servers. Planning the location of data, index, and Transaction log files on the disk.
• Involved in Database Maintenance, Releases, created SQL Agent jobs, Alerts, Operators when we did UK release.
• Wrote the DDL triggers for Auditing purpose, and also wrote automated audit process for Server configuration and scheduled to run once day.
• Database Management like adding secondary files, expanding file sizes, shrinking data files when we get Space issues.
• Cluster Administration, Supporting Log shipping, Linked Server configuration set up the Database Mail.
• Code review and send the recommendations to the Developers to improve the performance of the T-SQL like Stored procedures, User Defined Functions, Triggers, and Views
• Enforced the Database Security following corporate best practices (AD Groups, Users, Domain and SQL Accounts).
• Backup/ Restore, Automated DBA activities, Created and Scheduled the SQL Agent jobs, Alerts, Database Mail.
• Involved in providing 24 X 7 production support with trouble shooting, researching and provided permanent solutions. Also conducted root cause analysis for many critical Production tickets.
• Regularly performed SP Performance tuning, Maintenance, Code deployment, and Database Hot fixes.
• Technical Environment: SQL Server 2008/2005, Windows 2003 Server, .Net, Microsoft Visual Studio, T-SQL, Log Shipping, Replication, Clustering.

Environment: SQL Server 2008/2005, Windows 2003 Server, .Net, Microsoft Visual Studio, T-SQL, Log Shipping, Replication, Clustering.

Confidential, St Cloud, MN

Sr. SQL Server DBA/Developer

Responsibilities:

• Developed accurate database requirements for SQL Server 2008 on Amazon EC2
• Translated business requirements to technical specifications
• Developed multiple SSIS packages to enable data load from client files to database.
• Scripted out additional properties of database objects and created data dictionaries in html formats.
• Reduced running times on complex queries.
• Created Data QA standards for information inflow and outflow
• Migrated data from oracle 10g to SQL Server 2008
• Created and managed user roles and logins for different business lines based on the business requirement.
• Created stored procedures to access data in secured way.
• Created and maintained access specific roles to enable companies security policies for data access
• Automated some business processes using SSIS
• Planned and implemented geo distant database mirroring as a disaster recovery mechanism,
• Suggested geo distant replication as one of the disaster recovery solutions.
• Comprehensive Database Design for the company’s proprietary tools.
• Created Overall information flow diagrams for the company’s business
• Created, developed and refined Logical Entity relationship Diagram
• Developed ER diagrams for the entire DB architecture including 200 tables and 145 views
• Created and maintained customized security polices for the company limiting the unwanted and unauthorized data access.
• Managed Server, database and column level permissions.
• Designed and analyzed several data exchange mechanisms between the company and its clients ensuring safe, efficient and fast transfer of secured data.
• Limited the duties of sysadmin in order to achieve PCI compliance.
• Used Transparent Data Encryption to mask sensitive financial data in order to adhere to company’s security standards.
• Created and backed up private keys
• Collected logs on sensitive activities.
• Represented Company in client technical meetings at Mayo Clinic, Rochester

Environment: SQL Server, .Net Framework 2.0 / 3.5, C#.Net, ADO.Net, Windows Server, Amazon EC2, Redgate tools for SQL back up and Data Ppopulation.

Confidential - Minnetonka, MN

SQL Server DBA / Developer

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments using MS SQL Server 2005/2008.
• Troubleshot performance issues and monitored local and remote servers using Activity
• Monitor(SS08),Investigated data collected from Activity monitor
• Monitored server level and DB level log events using SQL Server Audit
• Collected and analyzed audit data to meet organizational security requirements
• Performed Database Refresh tasks from production to Development and Staging Servers
• Minimized the backup-time, restore-time, disk I/O and storage required for backups with Backup Compression.
• Monitored the servers over a period of time for memory usage and expensive query statistics using Data Collector and Management Data Warehouse feature, used the collected data in assessing changes to performance over the time period monitored
• Estimated data compression savings for VLDBs
• Created, maintained, reconfigured and enforced policies using PBM to satisfy business requirements
• On-Call support to esteemed customers to resolve with Disaster Recovery mechanism.
• Maintained two different databases: Read-only reporting database and Disaster recovery database
• Performed security tasks like Grant, Revoke permissions for security tasks.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
• Analyzed the pros and cons for using TDE on some DB with highly sensitive data.
• Monitored and tuned the server and databases using DBCC, server configuration options like sp configure and database option as sp dboption.
• Involved in auditing and performing the transactions to database and resolve the issues with PerfMon and SQL Profiler and Used NetMon for Monitoring and Performing Network throughput issues.
• Resolved issues for mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Developed Packages for Data transfer/Migration using SSIS Packages.
• Involved in building schema for the databases using HL7 Schema Generation tool.
• Performed and fine tuned Stored Procedures and SQL Queries and User Defined Functions.

Environment: SQL Server, .Net Framework 2.0, C#.Net, ADO.Net, JavaScript, VSS, HTML, Windows Server, SQL Safe 6.X.

Confidential

Jr. SQL Server Developer/Intern

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the zDatabase from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2000 / 7.0, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS.