We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume Profile

Chicago, IL

PROFESSIONAL SUMMARY:

  • SQL Server DBA with over 8 years of IT experience in administration, backup/recovery, Installation, testing, performance tuning and disaster recovery experience using SQL Server 2012/2008R2/2008/2005/2000.
  • Extensive work experience on system analysis, design, development, testing and implementation of projects, Trend reporting in the business with full SDLC Software Development Life Cycle .
  • Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs.
  • Excellent Experience in installing and maintaining Oracle Data guard to implement physical and logical Standby Databases for Disaster Recovery in 9i, 10g, 11g and Providing Critical Solutions with strategic Disaster Recovery Plans.
  • Experienced in installation, configuration and maintenance of Oracle 10g RAC databases.
  • Experience in migrating Standalone database to High Availability Oracle RAC Environment with ASM, Raw Devices.
  • Experienced in installation, setup and maintenance of Oracle Grid Control OMS, Repository Database and Management Agents in a High Availability environment for monitoring the databases.
  • Experience with OLTP and batch processing in a large data processing environment.
  • Extensive experience in installation and configuration of MS SQL Server 2005, 2008 and 2008R2 versions.
  • Good experience in implementing the disaster recovery models like mirroring, log shipping and transactional replication.
  • Experience in capacity planning in estimating troubleshooting and sizing of tables.
  • Good working experience on SQL Server command line utility.
  • Strong experience in trouble shooting database issues.
  • Experience in Scheduling and creating Sql Server jobs as well troubleshooting when jobs fail.
  • Experience in Database Backup and Recovery procedures.
  • Strong Knowledge in Oracle upgrades, patches, and downgrades along with Database cloning, Database creation and tuning including software disk device usage and tablespace configurations.
  • Experience in implementing the High availability models like Clustering.
  • In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance.
  • Experience in providing after hours and 24/7 database maintenance and support.
  • Capable of working both independently or in a team, Result Driven and Quick Learner with high sense of responsibility and Team work.
  • Capable of prioritizing tasks and solve complex problems and meet the deadline.
  • Experience in working closely with the Project team in clarification of requirements and communicated the same to the offshore team.
  • Able to share knowledge and train others if necessary.
  • Experience in using native tools like Data Base Tuning Advisor, Profiler and Activity Monitor for performance analysis.
  • Experience in monitoring SQL server performance using profiler to find the performance and dead locks.
  • Experience in performing BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Experience in using Indexes for improving query performance, lower storage and maintenance cost.
  • Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
  • Strong communication, negotiation and cross-group collaboration skills and also capable of maintaining key contacts outside the group.

TECHNICAL SKILLS:

Languages

T-SQL, C, C

RDBMS

MS SQL 2012/2008R2/2008/2005/2000, Oracle 8i/9i/10g/11g

Tools

SSMS, Citrix farm, Adept SQL, Idera SQL safe 6.0 Red-gate ,SQL Compare 10 and Data Compare 10,Visio 2010, , DTS, Profiler, LiteSpeed

Front End Tools

MS FrontPage 98/2000, MS Office 97/2000/2007, MS Outlook 2003/2007/2010

Operating Systems

Windows Server 2008R2/2008/2003, Windows 98/XP/Vista/7/8,MS DOS

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. SQL Server DBA

Responsibilities:

  • Understanding Customer requirement via interaction by planning and analyzing the specifications.
  • Installed configured SQL Server 2008 R2, Created Databases and database objects like Tables, Cluster/Non-Cluster Index, Unique/Check Constraints and Views with the support of developers.
  • Implemented database standards and naming convention for the database objects.
  • Involved in creating and monitoring jobs for daily Maintenance tasks like backups, checking integrity of databases and index maintenance.
  • Managed Security by controlling the access to the DB's and the server.
  • Used Audit functionalities to keep track of data manipulations.
  • Raised Change Requests for Hot Fixes on SQL server 2008R2 and implemented the Hot Fixes, Upgrades.
  • Day to Day Activities of SQL Server DBA. Running the Scripts T-SQL on the Prod server.
  • Deployed/Tested lot of SSIS Packages .dtsx for web services Project and TIVOLI upgrade project on DEV, QA and PROD and tested them and scheduled the jobs. Configured the Connection Managers thru .dtsConfig thru SSIS package Configurations to point to Oracle Data Source and destination- SQL Sever 2008R2.
  • Development of Maintenance plans and scheduling the Backups, Rebuild of Indexes, Cleanups, Update Stats.
  • Monitored the Performance of SQL Server 2008 R2 databases which are migrated using Performance monitoring tool PERFMON , ran Traces using SQL Profiler, Query Optimization is done table scan , Tuned the Indexes using Database Engine Tuning Advisor.
  • Generated custom and parameterized reports using SSRS and execution using SQL Server Business Intelligence Studio.
  • Responsible for rebuilding the indexes and tables as part of performance tuning.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Optimized queries using SQL Profiler and Database engine tuning advisor.
  • Involved in Implementation of Database maintenance plan.
  • Restoration of database from backups during accidental deletion or during a failure.
  • Retrieved the temp database when accidentally deleted.
  • Adding users in the database and granting permissions and assigning them to specific roles.
  • Creating and monitoring jobs for daily Maintenance tasks like backups, checking integrity of databases and index maintenance.
  • Importing and exporting data to and from database using Import/Export wizard.
  • Extract the data necessary for interfacing new products with the hotel database by using BULK INSERT.
  • Worked with developers to tune the SQL queries using SQL Profiler.
  • Involved in developing stored procedures, triggers for the application.
  • Maintained all the SQL Server documents which include installation and any modifications to the database.
  • Involved in Installation configuration Fail over Cluster, Log Shipping and database Mirroring, Replication.
  • Technical Documentation is prepared as per the Company's Policies.

Environment: SQL Server 2008R2, Oracle, Windows 2003-XP, Windows 2008, T-SQL, PL/SQL.

Confidential

Role: SQL Server DBA

Responsibilities:

  • Upgraded the Existing SQL Server Data base version 2008 to the SQL Server 2012.
  • Designed and implemented the Clustered Server environment for high availability both in Physical Environments.
  • Installing, configuring, administering and securing production and non-production servers.
  • Created Logins, users roles and involved in Daily User Maintenance.
  • Created Database Maintenance jobs to perform full transaction log Backups and scheduled them with the SQL Server agent job scheduler.
  • Monitor database growth activities Troubleshoot Transaction Log Issue.
  • Created and configured mirroring in case of Disaster Recovery problems
  • Worked closely with the Project team in clarification of requirements and communicated the same to the offshore team.
  • Providing weekly status information on all the projects to Project Manager
  • Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance.
  • Worked with Performance Tuning/Query tuning ,execution plans, trace flags and SQL Profiler
  • Installation of Service packs to all environments.
  • Used log shipping for synchronization of databases.
  • Monitored and modified Performance using execution plans and Index tuning
  • Created new tables, stored procedures and triggers in T-SQL.
  • Refactored and Fine-tuned the queries and Stored procedures in T-Sql.
  • Performing DB backups, restores ,clean-up DB maintenance activities in a large like log file monitoring, statistics update, performance tuning, disaster recovery
  • Verify Backups by restoring on to test server, Monitor Performance, check for missing indexes and
  • Create, drop unused indexes
  • Performance Tuning of the Stored Procedures.

Environment: Citrix farm, Windows 2003 servers 32 and 64 bit mix , SQL Server 2008/2012,Adept SQL ,Idera SQL safe 6.0,Red-gate SQL Compare 10 and Data Compare 10,Visio 2010.

Confidential

Role: SQL Server DBA

Responsibilities:

  • Installed and maintained SQL Server database systems by ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
  • Involved in migrating from SQL Server 2005 to 2008 R2.
  • Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Designed, documented, and promoted security best practices , policies, standards and protocols
  • Deployed maintenance plans for regular DBA activities .
  • Worked with development and systems teams to perform application and database tuning
  • Involved in Normalization, Database design, Performance Analysis and Production Support for very large VLDB and Complex Databases.
  • Used native tools like DATA BASE TUNING ADVISOR, PROFILERand ACTIVITY MONITOR for performance analysis.
  • Handled Memory configurations for SQL Server 2005/2008R2 on Windows 2008R2.
  • Created Documentation for steps needed to be taken while upgrading the SQL server 2005 to SQL server 2008R2.
  • Provided database highly available and application infrastructure according to Business Continuity requirements using SQL clustering, etc.
  • Checked Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning
  • Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
  • Prepared Documentation for the Disaster Recovery plan. Worked in Active passive cluster environment.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Daily routine Developer/DBA tasks like handled user's permissions and space issues on Production and handled maintenance Jobs including backups and restores.
  • Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
  • Monitored SQL server performance using profiler to find the performance and dead locks.
  • Worked on call 24/7Support on weekly basis

Environment: SQL Server 2005/2008R2 with clustering, Replication, T-SQL, Windows 2008 64-bit, Profiler.

Confidential

Role: SQL Developer/DBA

Responsibilities:

  • SQL Server 2005/2008 Database Administration.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Involved in the migration of SQL Server 2005 databases to SQL Server 2008R2.
  • Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
  • Established Maintenance Plans for Regular Backups and Index rebuilding.
  • Expertised in Tuning Slow running queries using Profiler and Statistics IO by using different approaches like evaluating joins, indexes, updating Statistics and code modifications.
  • Migrated DTS packages to SSIS packages and successfully implemented the Capacity planning for different servers.
  • Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
  • Checked Database Health by using DBCC Commands and DMVS. Automated and enhanced daily administrative tasks, including space management, backup Recovery and performance monitoring.
  • Wrote scripts to extract data from database tables and write the data to textFiles.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity, procedures and functions for business data transactions with error handling.
  • Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
  • Tuned stored procedures by adding the try catch blocks for error handling. Created the documentation for issue diagnostics reports.

Environment: Windows 2008, MS SQL Server 2005/2008,.Net, VB and ASP

Confidential

Role: SQL Server DBA

Responsibilities:

  • Installed and configured SQL Server 2005.
  • Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
  • Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
  • Created maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
  • Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Dropped and recreated the indexes on tables for performance improvements.
  • Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
  • Created indexes to speed the execution of data retrieval queries and stored procedures.
  • Applied Service Packs at database and OS Level.
  • Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations.
  • To set up SQL Server configuration settings.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Rebuilding the indexes at regular intervals for better performance.
  • Responsible for Stored Procedures optimization, Performance tuning index tuning.
  • Worked on Fail over Clustering for SQL Server databases for mission critical applications.
  • Provided necessary data validation checks against the data entry.
  • Frequently ran DBCC checks to maintain consistency.

Environment: SQL Server 2005, ASP, Windows 2003.

Confidential

MS SQL Server DBA

Responsibilities:

  • Involved in development activities including hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
  • Responsible for configuration ,Tuning of MS SQL Server 2005 and provided 24 X 7 dedicated support to all production and development servers.
  • Involved with Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005 Databases and Servers.
  • Responsible for migration of databases from one version to other versions and applying patches.
  • Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
  • Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
  • Actively involved in Normalization 3NF De-normalization of database.
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in replication problems.
  • Used DDM Data Dependency Mechanism to balance the load of data across multiple servers.
  • Responding to and resolve emergent service problems and automating to prevent problem recurrence
  • Involved in capacity planning in estimating troubleshooting and sizing of tables.
  • Developedcomplex Stored Procedures.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: Windows Server 2003,SQL Server 2005/2000, SQL Server Analysis Services, VB, SAN, DTS, SSIS.

Confidential

MS SQL Server DBA

Responsibilities:

  • Involved in installation and configuration of SQL server 2000 on Servers.
  • Applied patches and service packs to keep the database at current patch level.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Implemented database standards and naming convention for the database objects.
  • Implement and maintain database security.
  • Implemented trigger and stored procedures and enforced business rules via checks and constraints.
  • Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Going through the clients' requirements and coming up with database design and application architecture.
  • Troubleshoot and minimize production down issues.
  • Designed new job process, new database maintenance plans, and did performance tuning of the existing processes.
  • Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
  • Data conversions and data loads from various databases and file structures.
  • Monitor failed and long running MS SQL Server jobs.
  • Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
  • Maintaining User account administration for Different domains.

Environment: Windows server 2003, SQL-Server 2000.

Hire Now