System Analyst 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

Payton Vasamsetti

703-310-9876

payton@hotmail.com

                                                                 

SUMMARY

·          7+ years of IT experience includes System Analysis, Database Design, Development & Support of MS SQL Server 2005, 2000 in Production, QA & Development environments.

·         Configure, patch, test, monitor, and support all MS SQL Server db instances, monitor db performance.

·         Done DB configuration/SQL to optimize performance

·         Leads the design, testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.

·         Worked on Business Objects XI for report generation.

·         Used crystal reports for getting data in required format.

·         Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.

·         Implement and maintain Oracle Advanced replication option for various databases in different sites including multi-master replication read-only snapshots.

·         Accomplish day-to-day requirements of User Community.

·         Expertise in planning and implementing MS SQL server security and database permissions.

·         Good experience on migration and upgradetation

·         Experience in configuring, administering and maintaining Replication

·         Installed SQL server 2008 and setting environment.

·         Worked on reverse Engineering queries using Query Analyzer and SQL Trace.

·         Experience in Database Backup, Recovery and Disaster Recovery procedures.

·         Experience in writing and debugging stored procedures and triggers.

·         Able understanding and executing the details across multiple operations functions within the infrastructure.

·         Having excellent communication, analytical, and leadership skills.

·         Expert in technical and problem solving abilities.

·         Responsible for supervising staff in the execution of projects.

·         Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients.

·         Created PL/SQL packages, procedures and functions.

·         Expertise in SQL Loader and Import/Export Utilities.

·         Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML)

·         Experience in implementing different types of Replication models like Snapshot and transactional.

·         Experience in troubleshooting permissions, account lock-outs, network connectivity, services and IIS Administration

·         Hot and Cold Backups, Disaster Recovery Planning, Security Management, Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

·         Knowledge in DBMS environments and product interdependencies, as well as all major business unit application portfolios.

·         Experience in design, implement and maintain complex SQL Server 2000/2005/2008 e-Commerce database. 

·         Able to leads ensure all DBMS related functions are completed and ensures quality of execution, using trend data to lead continuous improvement efforts.

·          Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

·         Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

·         Expertise with Table Design, Index Design and Performance Tuning.

·         Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

TECHNOLOGIES

 

Databases	MS SQL Server 2008, 2005, 2000.
Programming	Visual Basic 6, C, C++ & T- SQL
DBA	Administration of MS SQL Server 2005, 2008, 2000 databases
Operating System	Windows 2008/2005/2003/2000 Advanced Server, NT, Oracle 8i, 9i.
Other Software	Active X, IIS, HTML, XML, Flash, ASP.NET
Tools	Performance Tuning, Backup Utility, Visio, IIS 7.0.
Network Topologies	TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP,DTS

PROJECT DETAILS:

Client   : Asurion, TN                                                                                                                                                                      Apr 2011-Till Date

Title     : SQL Server DBA

Company Profile Wipro Technologies is the global IT services business division of Wipro Limited. With over 20 offices around the world, Wipro Technologies is the No.1 provider of integrated business, technology and process solutions on a global delivery platform. Wipro Technologies is the leading end-to-end IT service provider offering solutions on Global Delivery Platform. 

Responsibilities

   

• Experience with SQL 2008 R2and all DBA tasks like replication, Clustering, log shipping.
• Experience migrating from Windows Servers 2000-2003 and 2003-2008.
• Test and upgrade in SQL 2008 R2 and implement database replication model.
• Upgrade database from SQL 2005 to SQL 2008.
• Experience with creating and maintaining database.
• Export or Import data from other data sources like flat files using Import/Exports through DTS, SSIS.
• Worked on performance of Table space, data file space errors, blocking locks, application errors Client software issues and Poor performance.
• Created all administration tasks of SQL Server and designed database.
• Created and modified procedures, triggers and functions.
• Manages and maintains all production and non-production databases.
• Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
• Configures database parameters, creates prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activities Advisor for index recommendations.
• Provide front-line response to events generated by database monitoring and alerting systems.
• Used System procedures and DBCC commands.
• Implemented and administrating SQL Server Snapshot replication and transactional replication
• Active Directory Administration, user logon scripts.

·         Experience in writing complex T-SQL queries using joins.

• Troubleshooting permissions,  network connectivity, services and IIS Administration
• Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.
• Provide training to the managers in using the system, using reports, executing complex queries and writing.
• Evaluated, examined and implemented user roles and assigned relative database access privileges.
•  Disaster Recovery Planning, Security Management, Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experienced in performance of the server using DMV commands.

      Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2, MS Access, T-SQL, MS Excel.

Life Synch, Irving, TX                                                                                                                                               July 2010-Apr 2011

SQL Server DBA

Life Synch is for changing behaviors and improves lives. Serves more than 10 million members and offers extensive resources over more than 20 years, commitment to well-being has resulted in positive outcomes for employers, health plans and insurers. Approach integrates the care of the mind and body – treating both the physical and mental together – to enhance health, and to increase personal and workplace productivity.  This includes behavioral healthcare, employee assistance program (EAP)/work-life services, behavioral pharmacy services, health coaches and Web-based wellness tools.

Responsibilities

• Created ERDs for databases.
• Experience with SQL 2008 and all DBA tasks like replication, mirroring, log shipping.
•  Experience migrating from Windows Servers 2000-2003 and 2003-2008.
• Test and upgrade in SQL 2008 and implement database replication model.
• Upgrade database from SQL 2005 to SQL2008.
• Experience with creating and maintaining database.
• Worked on performance of Table space, data file space errors, blocking locks, application errors Client software issues and Poor performance.
• Created all administration tasks of SQL Server and designed database.
• Created and modified procedures, triggers and functions.
• Maintained and developed modules on a multi server, e commerce application
• Wrote T-SQL Queries and involved in programming of stored procedures, triggers, cursors, functions to implement the business logic
• Used System procedures and DBCC commands.
• Implemented and administrating SQL Server Snapshot replication and transactional replication
• Active Directory Administration, user logon scripts.
• Troubleshooting permissions,  network connectivity, services and IIS Administration
• Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.

·         Knowledge of MS SQL Server clusters.  Power Designer or similar modeling tools.

• Provide training to the managers in using the system, using reports, executing complex queries and writing.
• Evaluated, examined and implemented user roles and assigned relative database access privileges.

·         Testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.

• Created automatically running stored procedures for day-end operation using SQL Server Agent.

      Environment: Windows 2003/2008 server,  XML, MS SQL Server 2000/2005/2008, MS Access, T-SQL, MS Excel, ASP.NET Visio, UNIX, IIS 7.0.

____________________________________________________________________________________________________________

   

Bethesda Health Group, St Louis, MO                                                                                                                   Jun 2008 – Jul 2010

SQL Server DBA

Bethesda Health Group provides senior care and retirement communities with an equal focus on superior quality and value. Our team promises to bring needed services to St. Louis seniors in the most efficient and desirable way - from 24/7 skilled nursing, to innovative memory care environments, to in-home assistance - Bethesda Health Group delivers care wherever St. Louis seniors call home.

Responsibilities

• Used database mirroring for transfers transaction log records directly from one server to another and can quickly fail over to the standby server and database.
• Client applications were originally interactive command-line tools with graphical user interfaces have been developed for all desktop operating systems.
• Manages and maintains all production and non-production databases.
• Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
• Configures database parameters, creates prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements.
• Provide front-line response to events generated by database monitoring and alerting systems.
• Designed and developed primary database objects (tables, views, indexes).
• Export or Import data from other data sources like flat files using Import/Exports through DTS, SSIS.
• Good experience on analyzing OLAP databases group the related facts in a member into hierarchies Provide account administration for all database resources.
• Created SSIS Packages that loaded IIS log files into a SQL Server 2005 database for site usage reporting. 

·         Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services.

• Enhanced the coding guidelines document for SQL developers
• Good experience in data modeling and metadata services.
• Migrating SQL Server 2000 data bases into SQL Server 2008.
• Hands on experience with backup and restoring databases
• Checking Database Health by using DBCC Commands

·         Knowledge of MS SQL Server clusters. 

Environment: Windows 2003 server, XML, MS SQL Server 2000/2005/2008, MS Access, MS Excel, Visio, IIS.

Client     : Bank of America, Charlotte, NC                                                                                                        Jan 2006– May 2008

Title       :  SQL Server DBA

                    

Bank of America is the largest financial services company in the North America. The Financial team will be providing financial services and financial tools.  The objective of this project was to create a Consolidate Reporting Project. Build a data mart for the Retail Customer Service department. The data is from the call center coming from different modules.

Responsibilities: 

• Managed and Administrated the SQL Server 2005/2000 production and Non-production servers.
• prepared maintained and modified SQL server installation and configuration documents
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• 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.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) , Data Partitioning, Snapshot Isolation
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked in Cluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Database users and Roles.
• Writing stored procedures, triggers, and functions and maintained coding standards.
• Created and supported complex database schemas.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activities Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Monitored servers using Spotlight third party software.
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• 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.
• Worked on DTS, Import and Export utility, for transferring data.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Configured IIS, Report manager, Report server and implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked with Application Developers to design databases and tables to support and achieve optimal efficiency.
• Configured SQL Server settings using configuration manager.

·         Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.

·         Handled numerous change management requests on production servers

  Environment: Windows 2003 server, XML, MS SQL Server 2000/2005, T-SQL, MS Access, MS Excel.

Cisco Technologies, San Jose, CA                                                                                                                    Mar 2005 – Dec 2005

SQL Server DBA

Cisco has evolved from Enterprise and Service Provider solutions to addressing customer needs in many other segments including Small, Consumer and Commercial. The network has truly become the platform for providing one seamless, transparent customer experience. As a DBA my role maintaining performance, migrating databases and upgrading.

Responsibilities:

·         Database Administrator, Database Programming.

·         Relocation of Databases from one server to another server using attach and detach databases.

·         Touch works application was implemented in Active Passive clustered environment.

·         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.

·         Migrated DTS packages from Legacy system to SQL SERVER 2005.

·         Migrated data from Oracle to SQL Server

·         Involved in Weekly Change Management, in which code developed by developers is being run on production server.

·         Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.

·         Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

·         Monitored and modified Performance using execution plans and Index tuning.

·         Recovering the databases from backup in disasters

·         Maintaining the database consistency with DBCC at regular intervals

·         Used DTS packages to move logins and jobs from one server to another server.

·         Used Data Partitioning in SQL Server 2005.

·         Used Snapshot Isolation in SQL Server 2005.

·         Using log shipping for synchronization of database.

·         Expertise in SQL Server Reporting Services (SSRS).

·         Monitoring SQL server performance using profiler to find performance and dead locks.

·         Maximum performance and uptime in production environment.

·         To analyze long running slow queries and tune the same to optimize application and system performance.

·         Handled up to half  TB Size databases with clustered and replication environment

·         To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

·         To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.

·         To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

·         24 X 7 Production Database on Call Support.

Environment:  SQL Server 2000/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server,  XML. 

Aurobindo Pharmaceuticals, India                                                                                                                Feb 2004 – Feb 2005

SQL Server DBA

Aurobindo Pharma Limited, is one of the world’s leading pharmaceutical companies, based at Hyderabad, India manufactures generic pharmaceuticals and Active Pharmaceutical Ingredients. It is one of the world's top 5 manufacturers of semi synthetic penicillin.

Responsibilities:

·         Installation and Configuring the MS SQL Servers.

·         Involved in designing the data model for a normalized database.

·         Involved in creating normalized Databases, creating objects, sizing temp databases.

·         Designing, programming and managing data interfaces, data validation and providing with data modeling.

·         Conducted in performance tuning, backup and disaster recovery processes and tools

·         Performance and tuning of SQL servers and application issues related to migration.

·         Testing of applications for performance, data integrity and validation issues.

·         Data Transfers between various servers using BCP.

·         Assisting developers with code enhancements, indexing the tables properly.

·         Writing the stored procedures, checking the code for efficiency.

·         Database monitoring using system tools and third party tools.

·         Administrative and Production support for various applications in all environments.

·         Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures, and Contingency plans. Testing and implementing these procedures.

·         Routine backups and restoration when necessary. Testing the backup and restoration plans.

·         Automated the dumps, loads, DBCC& reports by scheduling scripts in the Croon Jobs.

Environment:  MS SQL Server 2000, Windows 95/98, Windows N.T 4.0.

Download Resume Format