Sql Server Active Directory
Resume:
Cell: 469-***-**** Email:*************@*****.***
SUMMARY
Over 9 years of experience as MS SQL Server DBA in Development, Staging, Testing and Production environments.
Data Warehouse (DW) environments (OLTP and OLAP) with healthcare, financial, insurance and retail management domains.
Knowledge and in experience in converting SQL Security on databases from Active Directory IDs/Individual IDs to Active Directory Groups
Experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery and Running DBCC Commands
Experience in applying latest Service Packs and Rolling Patches and Upgrades for SQL Servers in Clustered (Failover) and Non-Clustered environments
Experience in Configuration and Maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2012/2008/2005
Installed and Configured SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
Involved in Implementing of multiple multi-node clustered community environments, which supported multiple instances of SQL Server
Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues with the same. Applied Hot fixes and Service Packs in clustered environments
Configured Database Mirroring in High Performance and High Availability mode and troubleshoot issues with the same
Experience in supporting Very Large databases (VLDB) and troubleshooting the associated problems
Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects
Verifying and tuning stored procedures created by developers by using Execution Plans, SQL Server Profiler and Database Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
Experience in administrative activities comprising Database Health Check, Index Optimization( Rebuild and Reorganizing Indexes with different fill factors), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, Database Security
Designing of Security – Active Directory Groups, Roles, Users and Kerberos Authentication
Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Experience in BI Development and Deployment of DTS, SSIS packages to migrate data from MS-Access, Excel, Oracle
Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service
Worked closely with management, applications development Team, and users on database solutions to resolve business problems
Providing the permission to Users\Object Level
Converting Active Directory user group as login in SQL Server
Synchronizing SQL Server Objects to Active Directory
Converting the Individual and Group level permission to the Database and Server Level
Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills
Auditing for changes to users, groups and computers, Directory Service Access events and monitor potentially far reaching effects of changes to organizational units, group policy objects, domains and site related objects.
TECHNICAL SKILLS
Operating Systems
Windows XP, Windows Server 2003,DOS,Unix, Linux
Database
MS SQL Server 2000, 2005, 2008 R2, 2012, Oracle 9i\10G
Monitoring Tools
Nagios, MOM, SCOM, BMC Patrol
Ticketing Tools
BMC Remedy, CA
Other Tools
SQL Lite-speed, Import-Export, BCP, Bulk Insert, SQL CMD
PROFESSIONAL EXPERIENCE
Blue Cross Blue Shield, Richardson, TX, USA Apr 2015 – Till date
Role: SQL Server DBA
Technology: SQL Server 2005, 2008 R2 & 2012
Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
Managing issues for database security, High Availability and implementing strategies accordingly.
Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
Daily administration, monitoring, and documentation of SQL Servers (2000\2005\2008\2008 R2\2012.
Monitoring replication and make correction actions in case of problems.
Monitor jobs execution, and make correction actions when necessary.
Deployment, configuration, troubleshooting and debugging of the application environments.
Exposure in deploying Application servers, and database servers with respect to product specifications.
Extending post-implementation, application maintenance and enhancement support to the client.
Good knowledge in Failover Clustering, DB Mirroring, Replication and Log shipping in (2000\2005\2008\2008 R2\2012).
Good knowledge and experience in security procedures, SQL Server security and auditing procedures.
Good experience in installing and configuring SQL failover clusters in SQL Server (2000\2005\2008\2008 R2\2012).
Leading database environment on SQL 2005/2008 with service pack upgrades and migrations to SQL 2005\2008\2008 R2\2012.
Align and set up database policy standards and security procedures for all servers globally.
Implemented project timelines and standards for SQL Server builds capturing pre-build phase, implementation, production readiness and final rollouts which helped in streamlining the existing initiatives and in giving estimates from the database perspective to various internal customers.
Investigating and Troubleshooting Database corruption\Recovery scenarios.
Solving the Query-Level as well as Server Level Performance Issues.
Nomise Systems Inc., Wichita, KS July 2012 – Jan 2015
Role: SQL Server DBA
Technology: SQL Server 2005, 2008 R2
Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
Managing issues for database security, High Availability and implementing strategies accordingly.
Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
Daily administration, monitoring, and documentation of SQL Servers (2000\2005\2008\2008 R2).
Monitoring replication and make correction actions in case of problems.
Monitor jobs execution, and make correction actions when necessary.
Deployment, configuration, troubleshooting and debugging of the application environments.
Auditing for changes to users, groups and computers, Directory Service Access events
Converting Active Directory user group as login in SQL Server
Synchronizing SQL Server Objects to Active Directory
Exposure in deploying Application servers, and database servers with respect to product specifications.
Extending post-implementation, application maintenance and enhancement support to the client.
Good knowledge in Failover Clustering, DB Mirroring, Replication and Log shipping in (2000\2005\2008\2008 R2).
Good knowledge and experience in security procedures, SQL Server security and auditing procedures.
Good experience in installing and configuring SQL failover clusters in SQL Server (2000\2005\2008\2008 R2).
Leading database environment on SQL 2005/2008 with service pack upgrades and migrations to SQL 2005\2008\2008 R2.
Align and set up database policy standards and security procedures for all servers globally.
Providing the permission to Users\Object Level
Converting SQL security on databases from Active Directory IDs to Active Directory Groups
Ensuring the Individual and Group level permission to the Database and Server Level
Implemented project timelines and standards for SQL Server builds capturing pre-build phase, implementation, production readiness and final rollouts which helped in streamlining the existing initiatives and in giving estimates from the database perspective to various internal customers.
Designing of Security – Active Directory Groups, Roles, Users and Kerberos Authentication
Investigating and Troubleshooting Database corruption\Recovery scenarios.
Solving the Query-Level as well as Server Level Performance Issues.
XBIA LLC, Wichita, KS Aug 2011 – July 2012
Role: SQL Server DBA
Technology: SQL Server 2005, 2008 R2
Project Lead for US region for all SQL Server related issues and escalations, globally responsible for escalations on critical issues in the database environment across different database areas like Performance tuning, Log shipping and day to day issues.
Responsible for bringing the SQL Server (2005/2008 R2) platform into the Application Management System for various new initiatives in the infrastructure space
Leading database environment on SQL 2005/2008 with service pack upgrades and migrations to SQL 2005/2008.
Engaged in maintenance of 150+ Database servers with 900+ databases across US
Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
Managing issues for database security, High Availability and implementing strategies accordingly.
Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
Daily administration, monitoring, and documentation of SQL Servers (2000/2005/2008/2008 R2).
Monitoring replication and make correction actions in case of problems.
Designing of Security – Active Directory Groups, Roles, Users and Kerberos Authentication
Monitor jobs execution, and make correction actions when necessary.
Auditing for changes to users, groups and computers, Directory Service Access events
Converting Active Directory user group as login in SQL Server
Synchronizing SQL Server Objects to Active Directory
Deployment, configuration, troubleshooting and debugging of the application environments.
Providing the permission to Users\Object Level
Ensuring the Individual and Group level permission to the Database and Server Level
Synechron Technologies Pvt. Ltd April 2011 to Aug 2011
Client: Asurion Japan
Role: SQL Server DBA
Technology: SQL Server 2005, 2008 R2
Managing and Monitoring SQL Data Growth.
Replication of Database server using Publisher and Subscriber.
Database Mirroring and Log Shipping.
Performing Backups and Restoration.
Providing the permission to Users\Object Level
Ensuring the Individual and Group level permission to the Database and Server Level
Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
Good knowledge in Failover Clustering, Replication and Log shipping in SQL Server 2000, 2005 and 2008.
Good knowledge and experience in security procedures, SQL Server security and auditing procedures.
Experience in usage of performance monitoring and troubleshooting, extensive use of profiler, Performance monitor, extended stored procedure, DBCC and DMVs for troubleshooting the performance issues.
Good experience in installing and configuring SQL failover clusters in SQL Server 2005 and 2008. And has good experience in maintaining and troubleshooting Active-Passive and Active-Active clusters.
Applying Service Pack on Standalone\Clustering Node.
Designing of Security – Active Directory Groups, Roles, Users and Kerberos Authentication
Investigating and Troubleshooting Database corruption\Recovery scenarios.
Solving the Query-Level as well as Server Level Performance Issues.
Patni Computer Systems Ltd – Mumbai Feb 2010 to April 2011
Client: MetLife USA
Role: SQL Server DBA
Technology: SQL Server 2005
Worked as Senior Database Administrator
Managing and Monitoring SQL Data Growth.
Replication of Database server using Publisher and Subscriber.
Database Mirroring and Log Shipping.
Performing Backups and Restoration.
Applying Service Pack on Standalone\Clustering Node.
Investigating and Troubleshooting Database corruption\Recovery scenarios.
Solving the Query-Level as well as Server Level Performance Issues.
Ensuring the Individual and Group level permission to the Database and Server Level
Mphasis HP Company\Saama Technologies Pvt. Ltd– PUNE April 2008 to Feb 2010
Client: Symantec
Role: SQL Server DBA
Technologies: SQL Server 2000, 2005
Worked as Senior Database Administrator
Managing and Monitoring SQL Data Growth.
Replication of Database server using Publisher and Subscriber.
Database Mirroring and Log Shipping.
Performing Backups and Restoration.
Applying Service Pack on Standalone\Clustering Node.
Investigating and Troubleshooting Database corruption\Recovery scenarios.
Solving the Query-Level as well as Server Level Performance Issues.
OmnitechInfosolutions Ltd–Mumbai Jan 2007 to April 2008
Client: Maharashtra state road transport corporation (MSRTC)
Role: Jr. Oracle DBA
Technology: OLAP, OLTP, Oralce10g Database, Application Server 10g
Worked as Junior Oracle DBA
Creating and managing databases required for development and testing.
Creating and Managing USER Accounts.
Extensive work experience on SQL*LOADER, EXPORT & IMPORT Utilities.
Database Storage and Space Monitoring.
Plans and implements backup and recovery of the database.
Installation and Configuration of ORACLE Application Server 10g.
EDUCATION & CERTIFICATIONS
BS, 2005 Mumbai University, INDIA.
Certified Microsoft Certified Professional (MCP).
Certified Microsoft Certified Database Administrator (MCDBA).
Certified Oracle 9i Database Administrator Certified Professional (OCP).
Workshop Completed on Oracle 9i Database Administrator from SQLSTAR International Ltd.
Completed 3 Years of National Institute of Information Technologies (GNIIT) Course from NIIT.
Contact this candidate