Sql DBA Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Maya Chhajed

Email: maya@gmail.com

Phone: 917-589-9876

                                                          

PROFESSIONAL SUMMARY: 

• Over Seven years of experience in MS SQL SERVER DBA ,Database Development       

             And Administration (DBA)

• Extensive knowledge of Relational Database Management Systems.
• Extensive experience in installation and configuration of MS SQL Server             

2000, 2005 and 2008 versions.

• Good Knowledge in Installing, Configuring and Maintaining SQL Server Active/Active & Active/Passive Clustering
• Experience in using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in Database Backup and Recovery procedures.
• Experience in Scheduling and creating Sql Server jobs as well troubleshooting when jobs fail.
• Experience in performance tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Hands on experience in trouble shooting database issues.
• Knowledge in writing and debugging stored procedures and Triggers.

·         Experience in MS SQL Clustering, Replication and Log Shipping.

• Experience in maintaining and supporting different types of Replication models like Snapshot, transactional and Merge.

• Experience in maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users.

• Worked on SQL Server 2005, 2008 tools like Management Studio, Business Intelligence management Studio,

·         Experience in SQL Server reporting Services (SSRS)

·         Experience in working high transacted OLTP systems

• Worked closely with management, applications development staff, and users on database solutions to business problems.

• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Dead Locks and Long running queries.

• Provided after hours and 24/7 database maintenance and support.

·         Good team player, strong interpersonal and communication skills

TECHNICAL SKILLS:

SQL Server Tools                    : Enterprise Manager, Profiler, DTS (Import & Export),                 

                                                 Query Analyzer, Replication, SSMS, SSIS.

Languages                               : C, C++, and T-SQL.

Operating Systems                   : Windows server 2003, Windows 2000 advanced

                                                 Server/server/professional, WindowsNT/95/98/ME/X, MS DOS

Data Bases                              : MS-SQL Server 6.5/7.0/2000/2005/2008

                                                 MS Access 97/2000/2003

Front End Tools                        : MS FrontPage 98/2000, MS Office 97/2000/XP,

                                                 MS Outlook 97/2000.

Database Tools/IDE                 : Erwin.

Reporting Tools                        : MS SQL Server Reporting Services, Microsoft Operations

                                                 Manager (MOM).

EDUCATION

Bachelor of Science in Electrical Engineering

University of Mumbai, India

Master of Science in Electrical Engineering

University of New Haven, West Haven, Ct

PROFESSIONAL EXPERIENCE:

Kaplan Inc, New York City, NY                                               (June 11 –Till Date)

Sql DBA

• Installed and configured 2-node and 4-node Cluster Configuration (Active/Active /Active/Active) in SQL Server 2008 R2, 2005.
• Maintaining design structure by directing implementation of SQL standards and guidelines.
• Completing platform upgrades and migrations by issuing instructions; monitoring performance; coordinating actions to maintain system currency.
• Migrated SQL Server 2000, 2005 to 2008\2008 R2
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008/ R2 for high availability.
• Successfully setup and maintained Transactional Replication and Merge Replication.
• Created and Scheduled SSIS Packages as per ETL requirements.
• Created and maintained database Maintenance Plans.
• Prepared documentation on Capacity planning of all servers and made recommendations.
• Played a major role in Data Center Migration from Chicago to New York
• Designed and Implemented Disaster Recovery Procedures like Log Shipping.
• Tested and implemented Backup Strategies.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user defined functions.
• Extensively documented all the server configurations, databases, database objects, jobs and the changes to the database.
• Documentation and Automation of various database related procedures.
• Created Linked Servers to distribute data from one server to another server.
• Solved issues related to Server performance and Disk space.
• Resolved issues related to query optimization, database optimization and index tuning.
• Extensive experience in backup tools like Snap Manager for large Data Ware House Environment
• Migrated all Jobs from SQL Server to Job Maintaining tool Tidal
• Migrated Spotlight to 2008 R2 and application to higher version
• Migrated Password Manager 2008 R2 and application to higher version
• Maintaining data integrity by establishing standards; monitoring performance.
• Maintaining database performance by developing tuning methodologies.
• Developing and maintaining production, staging and back-up database support documentation.
• Assisting in support for resolving system performance issues and malfunctions.

• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Creating New Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Dead Locks and Long running queries.

• Integrating new equipment and database software as it is purchased.
• Providing development support to software engineers by developing stored procedures as necessary.
• Providing information by collecting, analyzing, and summarizing database performance and trends.
• Write and maintain documentation as required.
• Accomplishing department and organization mission by completing related tasks as needed.
• Providing end-user database support.
• Providing 24x7 on call database support if required.

ENVIRONMENT: MS SQL Server 2000/2005/2008, T-SQL, Spotlight, Visio, Snapmanger, Tidal, Windows 2003, 2008 Server

Marsh Financial Services, Minneapolis, MN                                        (Feb10-May 11)

SQL Server DBA

·         Installed MS SQL Server, Performed Database Design and created User Databases

·         Performed migration of all the databases from Sql Server 2000 to Sql server 2008 along with all DTS packages to SSIS.

·         Troubleshooting of Upgrades issues like SQL Server 2000 to SQL Server 2008, Edition upgrades and hotfix upgrades

·         Scheduled backups and performed restore operations for system test data depending on developers’ requirement.

·         Created maintenance plan and sql server jobs and scheduling them, setting emails alerts on failure.

·         Created SSIS Packages to upload test data from Text files.

·         Managed Disk space, memory and User connections.

·         Tuned SQL Server using DMVs, SQL Profiler and Windows Performance Monitor.

·         Detected and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention

·         Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.

·         Performed query plans and made sure each and every query is using appropriate indexes.

·         Using profiler to find badly performing queries and deadlocks

·         Used DBCC checks and fixed data corruption in Application databases

·         Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.

·         Responsible for capacity planning, monitoring Disk I/O, CPU and memory

·         Responsible for Stored Procedures optimization, Performance tuning & index tuning.

ENVIRONMENT: MS SQL Server 2000 and 2008, Windows 2000 Advanced Server, Erwin

Pearson, Mesa, AZ                                                                                           (Aug 08-Jan 10)

SQL SERVER DBA

• Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.

·         Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up user & system databases and restoring.

·         Used SSIS to load various txt docs into Sql Server 2005.

·         Proper use of Views to prevent unauthorized access.

·         Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.

·         Created sql server backups as part of maintenance plan and monitor them.

·         Tested backup and recovery strategies in a test environment before and after moved to production environment.

·         Assist with the development and implementation of database standards and methodologies.

·         Created Linked Servers to retrieve, Join and Combine data with local data from remote servers

·         Configured Log Shipping to create a stand by server for production server.

·         Coordinated and performed quality assurance testing for movement of database and objects from development to testing and production environments.

·         Maintained and created Transactional and Snapshot Replication.

·         Responsible for stored procedures optimization, performance tuning and index tuning.

·         Responsible for keeping system and databases up-to-date by making necessary changes.

ENVIRONMENT: MS SQL Server 2005, T-SQL, SSIS, Windows 2003 Server.

Microsoft Corp, Charlotte, North Carolina                                             (June 07 – July 08)

SQL Server Product Support Engineer/ DBA

Microsoft is an American Multinational Computer Technology Corporation. It develops wide range of software products for computing devices. Microsoft, Charlotte is one of the support centers that have been supporting Microsoft’s best selling products like Microsoft Windows Operating System, Microsoft SQL server (integrated with many services like Analysis Services, Reporting Services, and Notification Services), .NET, VB, Share Point and many more. This support center has several expert teams that have been supporting customers during their typical installation and configuration issues, business linked software solutions and server down cases. SQL Core Team and performance team, in which I have been supporting and troubleshooting all the activities of Microsoft SQL Server (different versions), are of them.

·        Communicate with corporate customers via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software

·        Expertise in all the installation and configuration issues of Microsoft SQL Server (different versions). Including cluster setups

·         Find out the root cause and troubleshooting of cluster failover

·         Troubleshooting of Upgrades issues like SQL Server 2000 to SQL Server 2005, Edition upgrades and hotfix upgrades

·         Every type of performance issues like server wide performance issue, database wide performance and stored procedure tuning issues( with the help of pssdiag , readtrace utility and performance dashboard reports)

·         Replication configurations and troubleshooting replication issues like replication agent’s failure, and performance issue

·         Troubleshooting issues related to tools, Management Studio/SEM, SQL Agent – scheduled tasks, Maintenance Plans, Import/ Export Wizard, Migration Advisor

·         Expertise in Server Management like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach

·         Troubleshoot data corruption issue (Server down situation), understand the dbcc checkdb output, planning of disaster recovery

·         Expertise in configuring and maintaining log shipping, database mirroring, replication and clustering

·         Troubleshooting security and permission related issues, all type of memory related issues (like: out of memory error), basic connectivity issues and full text search issues.

·        Expertise in handling server failures and analyzing stack dumps(non-yielding and exception analysis)

ENVIRONMENT: MS SQL Server 2000/2005/2008, T-SQL, Windows 2003 Server.

Iowa Health Systems, Cedar Rapids, IA                                                (Jan 07– June 07)

SQL Server DBA

·        Worked on the consolidation of all database servers to a two node windows 2003 cluster.

·        This involves database upgrade of all 7.0 servers and 2000 servers to sql 2005 and moving the database to the cluster node.

·        Developing Backup & disaster recovery strategies and implementing on all production servers.

• Installing and managing Active/Active cluster servers on Windows 2003
• Providing support to production database.
• Creation of DTS, SSIS packages, and ActiveX Scripts to load Data.
• Experience in writing stored procedures, triggers and Views.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Using profiler to find badly performing queries and deadlocks.
• Creating and managing schema objects such as tables, views, clustered indexes, procedures, triggers.
• Server fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Installing SQL Server service packs based on the errors and flaws that are found in the application
• Helping QA personals in deploying and testing the application, which uses SQL Server as a database

Environment: MS SQL Server 2005, MS Outlook, TSQL, SQL Server Business Intelligence Development Studio.

Thermatool Corp, East Haven, CT                                                       (June 06 – Dec 06) 

SQL Server DBA

Thermatool one of the leading manufactures for high frequency welders, cutoffs, and heating equipment for the production of pipe and tube. Thermatool’s innovative approach to process high grade materials applies proven designs to evolving industry needs.

RESPONSIBILITIES

·         Building Database design using Erwin, creation of user databases, Installation of MS SQL Server & Clients

·         Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.

·         Managing the SQL Servers in Clustered Environment.

·         Monitoring the replication between two sites, Support and maintenance of MS SQL Server Transactional Replication

·         Migrated database, logins and passwords from various Sql Server 2000 instances to Sql server 2005.

·         Running DBCC consistency checks and fixing data corruption in application databases.

·         Installing SQL Server service packs based on the errors and flaws that are found in the application

·         Using Data Transformation Services (DTS) to populate data from various data sources    

             Using the concept of OLE DB    

·         Implementing disaster recovery site, procedures and testing the same for disaster recovery purposes.

• Worked on linked servers to run distributed queries between SQL server and other data sources using ODBC, OLE DB Drivers.

·         Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.

·         Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

·         Assigning the users to particular groups. Database objects ownership types.      

Security and auditing on SQL Server.

• Providing support to the Application developers on the application databases.

ENVIRONMENT: Erwin 7.1, SQL Profiler, Query Analyzer, Enterprise Manager, SQL-Server 2000\2005, Active/Passive cluster.

              

                                                                                                           

Mohanraj Trading & Exchange Ltd, Mumbai, India.                                                          (Feb 05-Nov 05)

SQL Server DBA/Developer

Mtel is one of the leading foreign exchange brokers in the city of Mumbai, offering private individuals and companies the ability to achieve significantly better foreign currency exchange rates and exceptional service.

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, DTS programs 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: SQL-Server, DTS, T-SQL,

                                                 

Download Resume Format