Senior SQL DBA

Skills

Employment History:

Confidential

Sr SQL Server DBA

Responsibilities:

• Responsibility includes supporting Databases, troubleshooting, planning and migration in development, QA and Production environments.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Creating and maintaining various databases on Production and development environments using SQL Server 2008-R2/2005/2000.
• Installed SQL Server 2012 on test environment to the future production.
• Automating the database administration tasks using SQLCMD, T-SQL and PowerShell.
• Involved in Database Backup and recovery. Implementing Point-In-Time Recovery solutions
• Installed and administered Active/Passive cluster on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment
• Monitoring of database size and disk space in Production and Development environments.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Had in-depth knowledge of SQL 2012, SQL 2005, and 2008.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.
• Scripting the Database Consistency Checks DBCC , scheduling the scripts to run daily and weekly basis.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
• 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 installation, configuration, and maintenance and migration of MS SQL Server 2005, 2008 on various environments.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Created various reports using SSRS.
• Experienced in troubleshooting configuration and management of Oracle 10g and 11g.
• Experience in Operational management and in-depth troubleshooting replication problems in MS SQL 2005, 2008 and 2012 Environment to Test the Software.
• Designed, installed and maintained SQL Clustering as a High availability solution.
• Maintenance and database analysis tuning and Migrating Databases from MS SQL 2008 and above.
• Extensively worked on SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS .
• Expert in implementing the snapshot isolation and DDL triggers.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Experience with windows servers 2012, 2008, and 2003 operating systems.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Created monitoring scripts to alert for production issues.
• Design, deployment and manage SQL environment using SQL Server Reporting Services SSRS and SQL Server Management Studio.
• Performed Production support and on Call duties.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers, handling maintenance Jobs and table partitioning.
• Created necessary templates for various requirements gathering and documentation.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering ,Windows XP/2000 and Windows 2003/2008 Server, IBM e series Servers, Dell 6500 quad processors with 16 GB RAM

Confidential

Position: Sr SQL Server DBA

Responsibilities:

• Responsibility includes configuring, administration and troubleshooting multiple databases in development, QA and Production environments.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 R2.
• Performed Structural changes to Database like creating tables, adding columns, creating indexes according to business requirement.
• Involved in Data Modeling and Designing.
• Efficiently handled production environments with more than 100 servers, Databases ranging 200 GB 1 TB.
• Installed and maintained SQL Server 2008 R2 on VM's.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored performance by using SQL Profiler and Quest Spotlight and documented it.
• Worked on QUEST Lite Speed tool for Backup/Recovery.
• Created and maintained logins and groups with appropriate permissions.
• Implemented and maintained database security by creating users, roles and assigning privileges.
• Experience in Working and troubleshooting High Performance Asynchronous Database Mirroring which is used as a High availability solution.
• Experienced in troubleshooting configuration and management of Oracle 10g and 11g.
• Responsible for installation, configuration, and maintenance and migration of MS SQL Server 2005, 2008 on various environments.
• Had in-depth knowledge of SQL 2005, and 2008.
• Experienced with windows server 2003, 2008 operating systems.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Maintenance and database analysis tuning and Migrating Databases from MS SQL 2008 and above.
• Configured Transactional Replication between Primary Server and Read Only servers, with separate Distributor server
• Experience in Operational management and in-depth troubleshooting replication problems in MS SQL 2005, and 2008 Environment to Test the Software.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Published and deployed reports on multiple Report Servers.
• Designed, installed and maintained SQL Clustering as a High availability solution.
• Performance tuning using Execution plan, Profiler, Perfmon, Extended Events and Resource Governor.
• Design, deployment and manage SQL environment using SQL Server Reporting Services SSRS and SQL Server Management Studio.
• Responsible for proper support planning with project managers and developers.
• Lead in all the archive and Purge processes both on the production and the report servers.
• Coordinated with various teams and architects to maintain the BNY Mellon standards and procedures.
• Documented the end-end migration process incompliance with BNYM standards.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Environment: MS Windows 2008R2/2003 Server, MS SQL Server 2008R2/2008/2005, IBM e series Servers, VMware vCenter, Dell 6500 quad processors with 16 GB RAM, Quest Lite Speed, Quest Capacity Manager.

Confidential

Position: SQL Server DBA

Responsibilities:

• Responsibility includes configuring, administration and troubleshooting multiple databases in development, QA and Production environments.
• Upgrading SQL Server 2005 to SQL Server 2008 R2 on Testing, Development and Production Environments.
• Worked in 2 node Active/Active Clustered Environments.
• Designed, installed and maintained SQL Clustering as a High availability solution.
• Installed and worked on SQL Server 2008 With Service Pack 2 on stand-alone client and testing machines.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 R2.
• Monitored performance by using SQL Profiler and Quest Spotlight and documented it.
• Worked on QUEST Lite Speed tool for Backup/Recovery.
• Experienced in troubleshooting configuration and management of Oracle 10g and 11g.
• Had in-depth knowledge of SQL 2005, and 2008.
• Configured transactional replication between Primary Server and the Report Server, with separate Distributor server.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Played lead role in database security cleanup for all Production servers for PCI Compliance.
• Created and maintained logins and groups with appropriate permissions.
• Experience in Operational management and in-depth troubleshooting replication problems in MS SQL 2005, and 2008 Environment to Test the Software.
• Implemented and maintained database security by creating users, roles and assigning privileges.
• Experienced with windows server 2003, 2008 operating systems
• Responsible for installation, configuration, and maintenance and migration of MS SQL Server 2005, 2008 on various environments.
• Maintenance and database analysis tuning and Migrating Databases from MS SQL 2008 and above.
• Created jobs, alerts, activity logs, error logs to debug any possible errors.
• Created and deployed SSIS packages on development and Production servers.
• Migrated DTS packages to SSIS using DTS migration wizard.
• Experience solving various issues faced migrating from DTS to SSIS.
• Experience creating SSIS packages for DTS which were not able to migrate for custom applications.
• Design, deployment and manage SQL environment using SQL Server Reporting Services SSRS and SQL Server Management Studio.
• Experience migrating SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages with configuration and log file.
• Created Credentials and Proxies for users to execute SSIS packages.
• Involved in creating DTS packages for archive process from Mainframes to MS SQL Server 2005.
• Worked extensively in Performance tuning, optimization of stored procedures and queries.
• Assisted developers to write SSIS packages according to the business requirements.
• Used BCP utilities to bulk insert Data.
• Used SSIS to copy data from SQL database to MS Excel files.
• Successfully implemented Database Mirroring with High Availability Mode in MS SQL Server 2005 and MS SQL Server 2008.
• Creating partition tables according to the requirement and business logic.
• Assisted the ETL team improve performance of their queries.
• Created and used Full Text Indexing feature in SQL Server 2005.
• Played major role in defining the SQL Standards to maintain code consistency.
• Writing scripts to create backup and restore.
• Writing DBA supported scripts for various jobs and tasks.
• Created reports using MS reporting services to generate reports for SQL safe backup and restore details.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed Structural changes to Database like creating tables, adding columns, creating indexes according to business requirement.
• Involved in Data Modeling and Designing.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.

Environment: : MS Windows 2003/2000 Server, MS SQL Server 2008/2005/2000, Oracle 10g, IBM e series Servers, HP ProLiant DL380 G4 with 12 GB RAM, IBM Fast T 700 Storage Area Network SAN , Quest spotlight, Quest LiteSpeed.

Confidential

Position: SQL Server DBA

Responsibilities:

• Responsibility includes configuring, administration and troubleshooting multiple databases in development, QA and Production environments.
• Installed SQL Server 2005 with SP2 and SSIS in development environments.
• Involved with upgrading from SQL Server 2000 to SQL Server 2005 on Development and Testing Environments.
• Installed and maintained SQL Server Analysis Services.
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in Data Modeling and Designing
• Generated test data and check databases consistency to meet the functionalities requirements.
• Responsible for installation, configuration, and maintenance and migration of MS SQL Server 2005, 2008 on various environments.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Design, deployment and manage SQL environment using SQL Server Reporting Services SSRS and SQL Server Management Studio.
• Configured MS SQL Server 2005 in-built Mirroring as a Disaster Recovery.
• Responsible routine DBA jobs like Backup and Restores.
• Had in-depth knowledge of SQL 2005, and 2008.
• Configured Various Replication Types between Primary Server and Read Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005 Environment to Test the Software.
• Installing applications and establish the connectivity with the database.
• Worked in 3- node Active/Active/Passive Clustered Environment.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Involved in installation of SSIS in Clustered Environments.
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database using migration wizard.
• Experience creating package configuration files for SSIS after migrating from DTS.
• Created SSIS packages for the archive and purge process from all the production servers.
• Experience transferring data from Access Server to SQL Server.
• Experience in resolving blocking and Dead Lock Issues by using SQL commands.
• Extensively worked in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler and using a monitoring tool called Quest Spotlight.
• Used Quest LiteSpeed as Backup/Restore tool.
• Used Diagnostic Manager from Idera solutions for Pro Active monitoring SQL Servers.
• Used Notification Services Available in SQL Server 2005 to create alerts and email notification.
• Creating Logins and Roles with appropriate permissions.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Experience in creating and supporting in OLAP Cubes.
• Experience with SQL Server Analysis Services SSAS .
• Had in-depth knowledge of SQL 2005.
• Providing support for the Development and QA Servers for SQL Server 2005/2000.
• Providing support to developers in Performance Tuning and Query Designing.
• Helped application Development Team in deploying and testing the application, which uses SQL Server 2005 backend.

Environment: : MS Windows 2003/2000 Server, MS SQL Server 2005/2000, Oracle 10g, IBM e series Servers,Dell 6500 quad processors with 16 GB RAM, Quest LiteSpeed, Quest Capacity Manager, RedGate Backup.

Confidential

SQL Server DBA

Responsibilities:

• Responsibilities include tasks such as database backups and restores, Log Shipping, database integrity verification and indexing updates.
• Responsibilities include Upgrading from MS SQL Server 2000 to MS SQL Server 2005.
• Installing, Configuring and Maintaining SQL Server 2005 with latest Service Packs, Hot Fixes.
• Implement Log Shipping in SQL Server 2005 from primary server to Standby server.
• Responsibilities include advising in Planning and designing the Logical and physical Data Modeling.
• Help the team to write and tuned Stored Procedures, Triggers, UDF, Queries.
• Extensively involved in documenting upgrading procedures and project plans from MS SQL Server 2000 to MS SQL Server 2005.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Responsible routine DBA jobs like Backup and Restores.
• Planned the Complete Backing up of Database and restoring the Database for Disaster Recovery.
• Creating back up strategies and scheduling them for execution.
• Performed Structural changes to Database like creating tables, adding columns according to Business requirements.
• Design, deployment and manage SQL environment using SQL Server Reporting Services SSRS and SQL Server Management Studio.
• Performance Monitoring using SQL Profiler, Windows System Monitor, System Stored Procedures, and DBCC Commands.
• Monitored SQL server LOGS, Application logs and analyzed the logs.
• Wrote stored procedures, Triggers, Cursors to implement business logic.
• Connected to the Source database tables using Source Analyzer, Created the required tables in the Target database-using Warehouse designer and mapped the columns using Mapplet designer.
• Worked with Designer, Supervisor, Broadcast Agent
• Implemented and documented proactive monitoring scripts for production databases
• Provided support for ETL developers in loading of client's data into SQL Server using ETL tool.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Configured built in log shipping with SQL Server 2000
• Importing and Exporting of the Database using DTS utility.
• Created and Scheduled DTS packages to transform data from Flat files and XML files etc.
• Creating, maintaining the users, roles and granting privileges.
• Use Full Text Search Service for search operation in journal database.
• Installing applications and establish the connectivity with the database.
• Worked with developers writing applications in Microsoft .Net.
• Performance Monitoring with Performance monitor and NETIQ Appmanager.
• Writing scripts to Create Jobs for Backup Restore Plans
• Environment: SQL Server 2005/2000, T-SQL, Visual Studio 6.0, Windows 2003/2000, NT 4.0, Erwin 3.5, Visual Studio.Net 2003, IBM Fast T 700 Storage Area Network SAN .