Sr SQL Server DBA/Developer
Resume:
Devi
g5kykz@r.postjobfree.com
________________________________________
Summary
Over 5+ years of experience as SQL Server Production DBA.
Expertise in Installing, configuring and upgrading of MS SQL Server 2008, 2005 and 2000 versions on both standalone and cluster environments.
Experience in migrating the cluster servers to new data centers and troubleshooting the issues during the migration.
Highly experienced in investigating and applying necessary SQL Server database service packs, Hot fixes and Security Patches.
In depth knowledge in creating SQL objects like tables, views, stored procedures, Indexes, Triggers, User defined data types, cursors and Functions.
Experience in T-SQL programming skills.
Extensive experience in Migration from DB2, Oracle to SQL Server.
Expertise in Data Center Migration in different methods i.e. Physical move, BMR and Virtual
Expertise in database Backup, Recovery and Disaster recovery procedures ( Logshipping, Mirroring, Replication and SRDF).
Hands on experience in troubleshooting Database Issues (Shrink files/Missing Log files, Update Status etc.).
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
Experience in writing and debugging Stored Procedures and Triggers.
Experience in implementing different types of Replication Models like Snapshot, Merge and transactional.
Maintained Database Authentication Modes, Creation of Users, Configuring Permissions and assigning roles to users.
Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
Experienced in migrating DTS Packages to SSIS.
Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.
Experience in SQL Server Reporting Services (SSRS).
Experience in creating data models and deploying to Report manager for developing Ad-hoc reports.
Experience with Veritas Net Backup configuration
Supported in Virtual Center Upgrading from ESX 4.1 to ESXI 4.1.
Experience in working with Red Gate, SQL Profiler, DTA and Erwin
Troubleshooting issues with Virtual Data Center
As a mentor Knowledge transferred to offshore team.
Worked closely with management, applications development staff, and users on database solutions to business problems.
Defined and administered database standards, controls, procedures and documented the same
Provided after hours and 24/7 Database Maintenance and Production Support.
Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
Technical Skills:
Operating Systems Windows Server 2003/2008, Windows XP/ 2000/ 95/ NT, Windows Power Shell
SQL Server Tools Enterprise Manager, Profiler, Query Analyser, PerfMon, Export & Import (DTS), SQL Server Management Studio, Vm Ware, SSIS, SSRS
Databases MS SQL Server 2008/2008r2/ 2005 / 2000 / 7.0, Oracle 10g Expression, MS Access, My SQL
Languages
Software Applications My SQL, SQL, Oracle PL/SQL, T-SQL, C, Ms-Word, Excel, Power Point.
Educational Qualification & Achievements:
Diploma in computer science from Kamala Nehru Polytechnic for Women, Hyderabad, India.
Apprenticeship in Hindustan Aeronautics Limited, Hyderabad from 2003-2004
MBA From International Technological University, Sunnyvale, California.
Professional Experience:
Client: Microsoft Corporation
Redmond, WA November 2011 – Current
SQL Server DBA
Microsoft Corporation is an American Public Multinational Corporation headquartered in Redmond, Washington, USA. Working as Tier 2 operational engineer supporting various property groups. Providing services to Enterprise service delivery team to improve the efficiency and automation of services.
Responsibilities:
• Installed and Configured SQL Server 2008 and 2008 R2 Servers.
• Managed 2005 SQL Servers
• Upgraded SQL Server 2005 to 2008 using In-place and Side by Side Upgrade in Prod, PPE and lab environments.
• Performed troubleshooting of database related issues during upgrading and migration process.
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions.
• Performance tune and Optimize frequently used SQL Queries, Indexes and Stored Procedures.
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Resolved issues in Mirroring setup.
• Solved backup, copy, restore job failure, space, network, latency Issues related to Log Shipping.
• Handled various issues related to setup and configuration of Database Mirroring, log shipping and replication.
• Implemented Transactional replication to Admin and Report databases and resolved the issues.
• Solved latency ,agent job failure, Synchronization issues related to Replication,
• Involved in scheduling Jobs, Alerts using SQL Server Agent as required.
• Created automation procedure for patching production servers.
• Involved in deploying changes to production and PPE environments.
• Involved in creating and renewal of SSL certificates.
• Developed and implemented backup and recovery strategies involving complete database backup/Restore, transaction log backup/restore.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler and also used Microsoft tools perf insight and perf analyzer.
• Did perform Administrative functions which are Update Statistics, Re-indexing.
• Involved in solving production issues on web servers and biz talk servers administration.
• Have Knowledge on power shell scripts to automate few tasks on production servers.
• Used SQL Profiler and Database engine tuning advisor for solving Deadlock, Performance Issues.
• Experience in migrating data from Reporting app server to SQL Server.
• Experience in writing Stored Procedures and VIews
• Worked with developers to tune the SQL queries and improve the Performance.
• Solved Issues related to Synchronization of Data in Development, Test ,Smoke, Production
Environments
• Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server.
• Provided 24 x 7 on call support for all the SQL application on production server.
Client: TCS-PWC
Tampa, FL
SQL Server OPS DBA November 2010 – November 2011
PwC (Officially PricewaterhouseCoopers) is a global professional services firm headquartered in London, UK. It is the world's second largest Professional services firm. It is one of the "Big Four" accountancy firms. Pursuant to the terms of our contract with PWC, TCS provides a wide range of technology services to PWC. TATA Consultancy Services (TCS) provides their services to PWC at Onsite and Offshore. TCS has a well-established management structure in place to provide full and complete managerial oversight to all PWC projects and the information technology professionals providing services.
Responsibilities:
We provide 24/7 System support to PwC, Pwc Data Centers meet Service Level Agreement(SLA) Obligations.
Transiting various Applications and Tasks to Offshore Locations
Providing support to Production and Application Environment
Deploys Applications on Productions Servers
Participating in Data Center Migration Activities, in different methods i.e. BMR, Virtual and Physical Move.
Troubleshooting issues occurred during Migration
Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2008/2008r2 on windows 2003/2008 Servers.
Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008/2008r2.
Monitoring and Troubleshooting jobs in Production, Stage and Development environment.
Installed and configured Report Server on windows 2008 server.
Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs.
Monitoring and Troubleshooting Cluster Resources in all other environments.
Installed SQL Server 2000/2008 on Active/Active and Active/Passive Multi Cluster Nodes.
Provided 24X7 production support for database and application issues.
Documented the results from the upgrade advisor and resolved the all issues encountered while migrating from SQL Server 2000/2005/2008.
Used third party tools like Red Gate, spot light and fog light in backing up databases
Experience in working with Third Normalization Form.
Experience in working with Database Objects like Tables, Views, Functions, Triggers and Stored Procedures, Indexing by using T-SQL Queries.
Experience in working with T-SQL Queries by using different commands like DDL, DML, DCL and TCL.
Good experience in working with Oracle 10g Expression.
Hands on experience in working with Vm Ware.
Experience in working with Unix.
Handling database objects with Enterprise Manager and Query Analyzer.
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.
Plan and Schedule the Online/Offline Backups.
Performing query plans and making sure each and every query is using appropriate indexes
Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility
Database Full and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
Maintained Log Shipping and Perform DBCC commands for database consistency.
Experience in working with Mirroring, Replication and new feature called as SRDF
Checked Performance Tuning, Indexing, Query Optimization.
Imported data from text files and excel spreadsheets into SQL Server 2005/2008 database by using SSIS.
Upgraded the Data Base Packages to SSIS Packages.
Creating and Configuring 2005/2008 SSRS.
Creating and renewing SSL Certificates
Creating and configuring Service Brokers and Linked servers between different servers
Responsible for developing and deploying reports using SQL Server Reporting Services(SSRS)
Created summarized reports using Reporting Designer.
Optimized the Disk space for performance using RAID and SAN.
Coordinated front end programmers in writing stored procedures.
Resolving Performance related issues to Blocking, Deadlocks and long running queries.
Optimized stored procedures and long running queries using query optimization techniques
Involved in setting up database mirroring for production server.
Environment: MS SQL Server 2008/2008r2/2005, Logshipping, Mirroring, Clustering, Windows 2003/2008, MS Office 2003/2008, T-SQL, VM Ware, Veritas, Litespeed, SSIS, SSRS, Replication.
E-Trade
San Francisco, CA June 09 – Oct 10
SQL Server DBA
E-Trade Financial Corporation is a Financial Services company based on New York City, United States. It provides financial services and products to its customers. It is a holding company, the major business of which is an online discount stock brokerage service for self-directed investors. Investors can buy and sell securities such as stocks, bonds, options, mutual funds, and exchange-traded funds via electronic trading platforms or by phone via E-Trade Mobile Pro. The company also offers banking and lending products such as checking and savings accounts, money market accounts, certificates of deposit, and credit cards. E-Trade is regulated and licensed by FINRA..
Responsibilities:
Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2008/ on windows 2003/2008 Servers.
Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
Experience with side by side and in place Upgrade.
Successfully patched the servers with appropriate hot fixes.
Experience in using high availability features i.e. Active/Active or Active/Passive cluster, logshipping, mirroring and replication.
Experience in performance tuning of long running queries and stored procedures by using SQL Profiler, Performance monitor and DTA
Monitoring and troubleshooting Cluster resources in all the environments.
Monitoring and Troubleshooting jobs in Production, QA and Development environment.
Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.
Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008.
Upgrading DTS packages to SSIS.
Involved in installing SSRS and configuring the Report manager.
Involved in configuring and troubleshooting the service broker.
Installed and configured litespeed on Dev, QA and Prod servers.
Involved in resolving the application slowness issue by tuning the stored procedures and monitoring the bottle necks.
Involved in trouble shooting blocking and dead locks.
Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.
Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs.
Implemented SQL Server high availability solutions including clustering, replication and log shipping
Worked in Active/Passive and Active/Active cluster environment.
Installed SQL Server 2005/2008 on Active/Passive and Active/Active multi node clusters.
Involved in configuring Logshipping and trouble shooting.
Experience in working with T-SQL.
Worked on call 24/7 Support on weekly basis
Environment : Windows 2003/2008 server, SQL Server 2005/2008, Replication, DTS, T-SQL, MS Access, MS Excel, Logshipping, Cluster.
iSpace Software Technologies Ltd., May 2005 - Sep 2008
Hyderabad, India
Jr.SQL Server DBA
iSpace Software Technologies, Ltd. provides healthcare business process outsourcing and technology services worldwide. The company is headquartered in Hyderabad, India. iSpace Software Technologies, Ltd. operates as a subsidiary of DST Systems, Inc.
Responsibilities:
• Installed, Configured and Administered SQL Server 2005.
• Involved in upgrading SQL Server 2000 to 2005.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively used SQL Server BCP Utility, DTS Import/ Export to load the database from text files received from different applications.
• Involved in configuring servers to implement high availability scenarios (Logshipping).
• Implemented in implementing replication.
• Involved in creation of DTS Scheduled Packages for the daily transfer of data from SQL Server Databases to Oracle database.
• Performance tuning and testing on stored procedures, indexes, and triggers
• Configured the Linked Server with the Oracle database.
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Monitoring SQL server performance using profiler and Windows System Monitor.
• Creating Maintenance plans and creating Alerts.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc. Automating Jobs and Creating Alerts.
• Automated consistency check of the database (DBCC) for SQL Server.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitoring the data file, transaction log and temp DB growth.
• Involved in applying Patches to SQL Server.
• Detected and corrected bugs during system integration and user acceptance testing. Set up a fail-over environment to support a production environment, monitoring the stand by server.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.
Environment : Windows 2003 server, SQL Server 2000/2005, Replication, DTS, T-SQL, MS Access, MS Excel, Logshipping.
Contact this candidate