SUMMARY:

• Around 10 years of experience in Database Administration, System Analysis, and production support

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTS, SSIS, Replication, SQL analysis services, reporting services

Databases: MS SQL Server 2012,2008, 2005, 2000 7.0, Rethinkdb 2.3.6

Languages: Transact SQL, MDX

Operating Systems: Windows Server 2003, 2008,2012, Cent Os 7

Data ware house: SQL server analysis services

PROFESSIONAL EXPERIENCE:

Confidential

Sr.SQL DBA

Responsibilities:

• Designed and configured Azure Virtual Networks (VNets), subnets, Azure network security groups, DHCP address blocks, DNS settings, security policies
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into VNets and subnets.
• Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets
• Setup Azure Virtual Appliances (VMs) to meet security requirements as software based appliance functions (firewall, WAN optimization and intrusion detections).
• Installed the SQL server on the AZURE VMS
• Migrated the My SQL databases to SQL AZURE by using the SSMA tool
• Configured the windows cluster and Implemented SQL always on
• Migrated the on prem SQL databases to Azure IAAS and PASS environments
• Installed and configured the Rethinkdb on Cent OS 7

Environment: SQL Server 2012, Microsoft Azure, PowerShell, Rethinkdb,SSMA, DMA

SQL DBA

Responsibilities:

• Installed the SQL server 2012 on the stand - alone servers
• Created the blank databases in SQL server
• Performed the deployments by using visual studio schema comparison tool
• Loaded the data from excel to database
• Implemented the maintenance plans
• Created the indexes, updated the statistics
• Resolved the dead locks
• Identified the long running queries and improved the performance
• Refreshed the lower environments with production database
• Implemented SQL server always on

Environment: SQL server 2012, windows 2012, visual studio schema comparison tool

SQL DBA

Responsibilities:

• Installed the SQL server 2008, SQL 2012 Configured the SQL server
• Installed the IIS 7 and configured the IIS
• Performed the deployments
• Implemented high availability technologies like failovers clusters database mirroring log shipping
• Created scripts backup the databases and delete the old backup files
• Created the SQL jobs and maintenance planes for the automation
• Implemented the database mail and implemented alerts
• Implemented the always on for the high availability
• Installed latest service packs and monthly security patches
• Trouble shoot the daily failures
• Created the stored procures to enhance the monitoring
• Migrated the SQL Reports from old hardware new hardware

Environment: SQL server 2008, 2012, windows 2008, Visual Studio 2010, SharePoint 2010, PowerShell 2.0,

SQL DBA

Responsibilities:

• Installed the SQL server 2008, SQL 2012 Configured the SQL server
• Installed the IIS 7 and configured the IIS
• Performed the deployments
• Implemented high availability technologies like failovers clusters database mirroring log shipping
• Created scripts backup the databases and delete the old backup files
• Created the SQL jobs and maintenance planes for the automation
• Implemented the database mail and implemented alerts
• Implemented the always on for the high availability
• Installed latest service packs and monthly security patches
• Trouble shoot the daily failures
• Created the stored procures to enhance the monitoring
• Migrated the SQL Reports from old hardware new hardware

Environment: SQL server 2008, 2012, windows 2008, lite speed, Visual Studio 2010, SharePoint 2010, PowerShell 2.0,

SQL DBA

Responsibilities:

• Implemented clusters on windows 2008
• Installed SQL Server 2008 on the cluster servers and configured the SQL server
• Moved the cluster disks from one group to another group
• Deployed the schema and stored procedures
• Implemented log shipping through lite speed
• Created jobs to run stored procedures implemented alerts for the jobs
• Created jobs to backup databases into multiple files
• Created logins and assign the permissions
• Applied every month security patches and rebooted the cluster servers
• Changed the SQL accounts passwords for cluster servers and stand-alone servers
• Trouble shot failed jobs added new data files to databases on the log shipping environment
• Trouble shot the rollup issues and log shipping issues
• Performed the deployments to enhance the process
• Uninstalled the SQL 2005 on the cluster server
• Destroyed the existing clusters on the server
• Applied the security patches for the servers
• Changed the passwords for SQL accounts
• Trouble shot the failed jobs
• Trouble shot the EMC replication jobs
• Trouble shot the slow running queries and other performance issues

Environment: SQL server 2008, windows 2008, lite speed 4.8

SQL DBA

Responsibilities:

• Performed the Full backup on production
• Ran the Trace on the production server and collected activity
• Restored production backup file on the lab server and converted into SQL 2005
• Analyzed the SQL 2000 Trace file in the Lab server by using RML tool,
• Ran the same activity on the SQL 2005 database in the lab by using ostress
• Compare the SQL 2000 and SQL 2005 performance by using RML tool
• Identified the slow running queries and tuned the long running queries
• Installed SQL server 2005 on stand alone and clustered servers
• Installed service packs on stand alone and clustered servers
• Installed the SSL certificates on stand alone and clustered servers
• Enabled the AWE on 32 bit servers
• Installed lite speed and configured the lite speed
• Configured the SQL 2005 according to BCBS standards
• Created alerts, backup jobs, maintenance jobs and configured the database mail
• Moved the physical disks from one cluster group to another cluster group
• Performed in place upgrade on stand alone server and cluster server
• Performed side by migration and moved to new hardware
• In the side by side and new hardware migration backup the database
• Restored on the destination instance and changed the compatibility mode
• Changed the page ferify option to checksum
• Rebuild the indexes, updated the Update Statistics and ran the DBCC update usage
• Copied the logins from source instance to destination instance
• Migrated the jobs and linked servers rebuild the log shipping and replication
• Implemented the database mirroring
• Converted the DTS packages to SSIS packages by using DTS x change tool
• Changed the connection strings in connection manager and tested the package in the lab
• Added the SQL server and XML configurations for the SSIS packages
• Created Integration Services Deployment Utility (Manifest file) folder
• Copied the Deployment Utility (Manifest file) folder to the destination server
• Deployed the packages on the destination server.
• Uninstalled the SQL 2000 on stand alone and clustered server

Environment: SQL server 2005, lite speed 4.8.4.00086, windows 2003, RML Tools,, Hp open view

SQL DBA

Responsibilities:

• Applied patches every month
• Installed the SQL server 2005, 2008
• Implemented database mirroring and performed manual failover
• Trouble shot the jobs
• Implemented the transactional replication trouble shoot the existing replication
• Performed the deployment of the scripts
• Truncated SQL log files increased the data file sizes and added new data files to databases
• Migrated the databases from old hardware to new hardware by using database mirroring
• Migrated logins and jobs
• Performed in place migration
• Resolved the blocking and dead locks
• Performed strip backup on very large databases and copied the backup files from sourceServer to destination server.
• Restored the database from multiple backup files
• Changed the SQL server service accounts passwords
• Provided 24/7 support
• Created partition function
• Created partition schema
• Re-created the clustered index on the partition schema

Environment: SQL server 2005, 2008, windows 2003, 2008, SCOM, cluster sentinel, SQL light speed, share point, IS, Hyper-V servers.

SQL DBA

Responsibilities:

• Monitored trouble shooted import export, maintenance, log shipping, replication jobs
• Implemented log shipping and performed change role
• Rebuild the log shipping standby databases
• Several times truncate the transactional log file
• Added the new data files for existing databases
• Increased the space in existing data files
• Resolved blocking issues in databases
• Troubled shot the slow running queries and applications
• Created indexes, updated index statistics and rebuild indexes
• Created SSIS packages to transfer the data from development to testing and production
• Several times truncated the tables and reloaded data into tables
• Restored user databases into point in time
• Restored the master database
• Performed strip backup on very large databases, copied the backup files from sourceServer to destination server.
• Restored the database from multiple backup files
• Installed the SQL server 2005 and applied service packs and hot fixes
• Migrated databases from SQL server 2000 to SQL server 2005
• Migrated logins and jobs from SQL server 2000 to SQL server 2005
• Migrated from DTS packages to SSIS packages
• Created maintenance plans for user and system databases
• Implemented database mail and created operator and assign the operator to jobs
• Transferred logins jobs SQL server 2000 to SQL server 2005
• Implemented database mirroring on SQL server 2005
• Deployed the scripts and tested stored procedures
• Assigned the privileges to newly created stored procedures
• Supported on call 24\7 on rotational basis

Environment: SQL server 2000/2005, windows 2003 advanced server, BMC, VERITAS,SQL light speed, NAS, SAN.

SQL DBA

Responsibilities:

• Installed SQL server 2005 on the servers according to the requirements.
• Applied Confidential approved service packs and hot fixes.
• Configured SQL server 2005 according to the requirement.
• Performed the hardening on the SQL server2005.
• Changed SQL directories owner to the Administrator account.
• Implemented audit policy in the system registry for SQL Server 2005
• Performed Full backup and restored on the SQL 2005.
• Transferred the logins, jobs, linked servers.
• Upgraded DTS packages to SSIS packages.
• Created SQL admin accounts and dropped the Built-in- Admin.
• Changed all jobs owner from SA account to administrator account.
• Disabled SA account.
• Created maintenance plan for user databases and system databases.
• Implemented data base mail.
• Created operator and assigned the operator to the jobs.
• Implemented database mirroring.
• Supported on call on rotational basis and supported the data bases 24\7.
• Configured the AWE.
• Created the script to find all SQL server version, license type, service pack.
• Created the script to monitor the all server’s logical disk free spaces.
• Resolved different kinds of tickets.
• Transferred the data base objects from dev to QA to prod.
• Removed guest users from databases.
• Revoked the privileges to Non-sysAdmins to execute the extended stored procedures like xp cmdshell.
• Revoked the public role object level permissions.
• Changed the SQL and SQL Agent account to domain accounts.
• Dropped the built-in Admin account.
• Disabled the SA account.

Environment: SQL Server 2005, 2000, windows server 2003, Hp Proliant, NAS, SAN, VB Script, SQL Light speed.

SQL DBA

Responsibilities:

• Changed the SQL service account from the system account to low privilege domain account.
• Changed the SQL agent account from the system account to low privilege domain account.
• Set the SQL server and SQL server agent to auto start.
• Changed the server form mixed mode authentication to windows authentication if mixed mode authentication is needed for any application installed the mitigating controls.
• Revoked the public role object level permissions.
• Revoked the direct object level permissions for the users.
• Revoked the xp cmdshell execute permission for the non -members of sysadmin.
• Created new sysadmin and revoked the built-in/ administrator’s system administrator privilege.
• Set the audit level to failure.
• Found the weak passwords and made the users to change the passwords.
• Configured the maintenance plan to backup the data bases on production servers.
• Installed the latest service packs (For SQL server 2000 sp4, for 2005 sp2).
• Implemented SQL mail, created operators and Alerts.
• Implemented data base mail in SQL server 2005.

Environment: SQL Server 2000, SQL Server 2005, T-SQL, Windows server2003 Server, SSIS, SSAS, Tivoli, IIS, Erwin.

SQL DBA

Responsibilities:

• Prepared application Run Books and checked in the sarena (PVCS).
• Made architecture and net work diagrams by using Visio.
• Performed the installation of SQL Server2000,2005
• Performed the data base backup.
• Zip and copied the backup files from source server to target server over network.
• Un zip the backup files and restored.
• Transferred the logins from source server to target server.
• Transferred the jobs from source server to target server.
• Transferred the DTS packages from source server to target server.
• Configured the DTS packages on the new server.
• Migrated the Ms Access data bases from source server to target server.
• Pushed the MSI’s and performed the SIT.
• Implemented the VERITAS net backup on new servers after passing OAT, UAT.

Environment: SQL Server 2005, 2000, 7.0 T-SQL, Visio, Excel, Advanced Windows 2000, 2003 Server, & PVCS Version Control Management.