PROFESSIONAL SUMMARY:
- Six plus 6 Years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Administering SQL Server High Availability and Disaster Recovery strategies.
- SQL Server 2012, SQL Server 2008R2, and experience in database clustering, mirroring and replication and good knowledge of SQL Server 2012R2 Always-on High-availability.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
- Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS configurations.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
- Extensively worked on SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
- Experience in supporting Very Large databases VLDB and troubleshooting the problems.
- Worked on configuring SQL Server with minimum privileged access.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Experience in Installing, deploying, configuring, monitoring web applications on IIS servers that runs on Windows server 2000, 2003,2008
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
- Experience in Configuring Websites on IIS 5.0 / 6.0/7.0 for high availability on various windows environments.
- Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Experience in Disaster Recovery Planning and Security Management operations.
- Experience in installing, configuring SQL Server 2005/2008 in large scale environments
- Experience in migrating applications between windows servers and to an upgraded platform from IIS 5 to IIS 6 and including IIS 6 to IIS 7
- Having hands on experience in DR processes including LogShipping and Database Mirroring.
- Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
- Having Experience on Data center servers and handling 1.4 TB databases.
- Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008
- Troubleshoot performance problems, fine-tuning of databases and index Analysis.
- Working knowledge of various digital media formats.
- Expert in Security Administration creating Users, Roles, Granting Privileges, Managing Schemas 2005 handling Database Security for windows/web applications.
- Strong experience in mentoring team members and writing documentation.
- 24 X 7 Production Database on Call Support
Technical Expertise:
- Databases: MS SQL Server 2012, 2008 R2,2008 MS SQL Server 2005
- Programming: Visual Basic 6, Visual Basic 5, C, C T-SQL, PowerShell2.0, 3.0
- DBA: Database administration of MS SQL Server 2012, 2008R2, 2008 2005
- Operating System: Windows 2008 R2/2008/2003 Advanced Server, NT Windows 9x, Linux
- Other Software: Windows 2008 R2/2008/2003 Advanced Server, NT Windows 9x, Linux
- Tools: Backup Utility, SQL Lite Speed, Visio
- Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SMTP
Professional Experience Details:
Confidential
SQL DATABASE ADMINISTRATOR
Responsibilities
- Migrated SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2008 R2 Enterprise Edition.
- Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
- Extensively worked on SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
- Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Automated messaging services on server failures, for task completion and success.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- 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.
- SQL 2000,2005 Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
- Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
- Experience in using PowerShell 3.0 script we scheduled the jobs,Session connectivity kind of stuff.
- Experience in Installing, deploying, configuring, monitoring web applications on IIS servers that runs on Windows server 2000, 2003,2008
- Experience in Configuring Websites on IIS 5.0 / 6.0/7.0 for high availability on various windows environments.
- Experience in installing, configuring SQL Server 2005/2008 in large scale environments
- Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
- Experience in migrating applications between windows servers and to an upgraded platform from IIS 5 to IIS 6 and including IIS 6 to IIS 7
- Rebuilding / monitoring the indexes at regular intervals for better performance.
- Expert in implementing the snapshot isolation and DDL triggers.
Environment: SQL Server 2008/2008 R2/2012Enterprise, Windows Enterprise Server 2008 R2 ,IIS 7.5, .NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Services.
Confidential
SQL DATABASE ADMINISTRATOR
Responsibilities
- Performed daily tasks including backup and restore by using SQL Server 2008 R2/2008tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
- Extensively worked on Dynamic Management Views in SQL Server 2005.
- Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
- Prepared DFDs Entity Relationship ER diagrams.
- Transferring the data ETL to Data warehouse Informatica by SSIS.
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
- Managed the migration of SQL Server 2000 databases to SQL Server 2005.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Perform business analysis, technical analysis, systems design, application software programming.
- Prepared the project management and technical documentation.
- Unit Testing the SSIS packages with respect to its flow and performance issues.
- Solving the Bugs Reflected by the Testing team.
- Rebuilding the indexes at regular intervals for better performance.
- Monitored and modified Performance using execution plans and Index tuning.
- Rebuilding the indexes at regular intervals for better performance.
- Extensively worked on DBCC commands and Dynamic Management Objects.
- Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Complete documentation about the database. Recovering the databases from backup in disasters.
- Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- To set up SQL Server configuration settings for better server management.
- Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
Environment: SQL Server 2008R2/2008 Enterprise, Windows Enterprise Server 2008,IIS 6.0, IIS7.5,.NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Service and ASP.
Confidential
SQL DATABASE ADMINISTRATOR
Responsibilities
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Rebuilding the indexes at regular intervals for better performance
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
- Monitored and modified Performance using execution plans and Index tuning.
- Rebuilding the indexes at regular intervals for better performance
- Deploying new code base release to UAT and Production Environments.
- Perform SQL Server service pack and Windows Service pack upgrades.
- Working with customers on Application rollouts and server migrations.
- Extensively worked on Enterprise Manager for managing the database
- Troubleshoot performance problems and fine-tuning of databases.
- Involved in Index Analysis and Performance Tuning.
- Converting DTS packages into SQL Server 2005 Integration Services.
- Migrating SQL Server 2000 data bases into SQL Server 2005.
- Recovering the databases from backup in disasters
- To analyze long running slow queries and tune the same to optimize application and system performance.
Environment: SQL Server 2005/2008, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.
Confidential
SQL DATABASE ADMINISTRATOR
Responsibilities
- Monitoring the server for High availability of the servers.
- Solving the request raised by user support.
- Participate in implementation of new releases into production.
- Facilitates application deployment and joint effort deployments.
- Meet the SLA Service Level Agreement established.
- Day-to-day administration of live SQL Servers.
- Designed and implemented Security policy for SQL Servers
- Used Stored Procedures, DTS packages, BCP for updating Servers
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers
- Automated messaging services on server failures, for task completion and success
- Execute procedures to accomplish short-term business goals.
- Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
- Deploying monitoring tools like Sitescope and spot light.
- Table partitioning to improve I/O access
- Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users
- Using database level triggers code for database consistency, integrity and security.
- Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.