SUMMARY:

• SEVEN years of total IT experience mainly as SQL Server Database Administrator in Mortgage Industry, Telecommunication industries, Insurance Industry and Waste Management Services.
• Proficient in managing OLTP and DSS environments and giving 24/7 production support
• Expertise in SQL Server 2008 R2, 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load.
• Expertise in Database Administration (DBA) tasks like Backups and Recovery, Log shipping, Mirroring, space utilization, load balance, process scheduling, security, replication, etc.
• Expertise in managing 100+ Server including SQL Server, Oracle and application server.
• Expertise in SQL Installation and Patching 2008 R2/2005/2000 on all windows servers.
• Proficient in Microsoft Standard Configuration.
• Implemented CLUSTERING, Mirroring, Log Shipping and Replication for DR and HA
• Expertise in design and Plan HA Strategy
• Understanding of ETL Process using Partitioned Tables, SSIS and Deploying SSIS Packages using Package Configuration along with Deployment utility.
• High Availability - RAC / Cluster / Replication / DataGaurd / Standby /Database Failover strategy
• Using DMV’s for performance analysis and Implementing Index Rebuild process for performance improvements based on Built - in SSMS reports.
• Expertise in system trouble shooting in production environment and development environments.
• Experience with VMware products.
• Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS)
• Expertise in work with End users and solving the issues.
• Expertise in work with Business Analyst and Developers to resolve the issues.
• Expertise in work on 24/7 environment with all day-to-day activities.
• Experience Starting and stoping the VI Client
• Good knowledge of data ware housing project with knowledge of OLAP and OLTP.
• Good Knowledge of SAN, LAN (local area network), WAN.
• Experience in Sharepoint including Administration, Development & Configuration.
• Expertise in developing stored procedure, Jobs and trigger in SQL Server 2008 R2 and 2005.
• Upgrade/Migration from earlier / legacy version to SQL Server 2008 R2/2005 using suitable methods.
• Expertise in supporting team of application developers for .Net web and OLTP database application.
• Involved and documented in SOP based activites.
• Experience in the designing, developing, Implementation and testing on production server.
• Involved in building data warehouse using ETL Tools for creating analytical reports.
• Ability to perform all common Database Administration (DBA) tasks like performing database backups and disaster recovery, space utilization, load balance, process scheduling, security, clustering, etc.
• Experience in Performance Tuning, Indexing and Query Optimization. Understanding of Query Execution Plans.
• Used third party tools like IDERA, RED GATE, SQL Litespeed for Backup and Monitoring
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Expertise in making documentation on SQL server 2008 R2, 2005.

TECHNICAL SKILLS:

Operating Systems: Windows server 2008 R2 / 2003, VMware

Database: SQL Server 2000, 2005, 2008, 2008 R2, ORALCE 9i, MS- Access.

Programming Languages: C#, Core Java, T-SQL, LOTUS

Tools: & Utilities:IDERA, Red-gate tool for back-up, Light speed, SQL Safe

Internet Technologies: ASP.NET 1.1, ASP, VB Script, HTML, DHTML, Java Script, XML

Reporting Tools: SSRS, SSIS, Share point, Crystal Reports

Development Environment: Visual Source Safe, Serena

SQL Server Tool: Enterprise Manager, Profiler, Query Analyzer, Export and Import

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, Mo

Database Administrator / Production Support

Responsibilities:

• Provide Production Support and give 24/7 on-call support
• Involved in the DB Migration process from one Data Center to another data center.
• Installed and Configure SQL 2008 R2, SQL 2008 Active/Active and Active/Passive Cluster on production servers.
• Day-to-day Technical Support on MS SQL Server 2008 R2/2005 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Implement code changes and configuration changes (if needed) and other administrative activities.
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008/2005.
• Technical support to users for various purposes like Access change, performance issues and storage space managements on RAID/SAN drives.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performon counters with System Monitor.
• Created SSIS Packages on production and development environment.
• Recommend possible remedies for better performance.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Work in cooperation with developers/team for of efficient database access for applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.
• To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
• Setting up Transactional and snapshot Replication for Production Environment.
• Running various DBCC commands for administration of database objects and system performance.
• 24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.
• To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
• Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.
• Interaction with client and onsite team members.

Environment: SQL Server 2008 R2, 2008, 2005, 2000, SSIS, SSRS, SQL Safe, IDERA, SQL Litespeed.

Confidential, Irving, TX

Database Administrator and SQL Developer

Responsibilities:

• Installed MS SQL server 2005 and 2008 R2 on all production servers and also VMware products.
• Worked on Data Center Move project.
• Up gradation/Migration from earlier / legacy version to MS SQL Server 2005/2008 R2 using suitable methods.
• Interacted with Business Analysts and Developers in identifying the requirements and designed SQL server accordingly.
• Administered MS SQL Server security by creating user logins with appropriate roles, monitored the user accounts, created groups and granted the privileges to users and groups.
• Worked with Developers to identify the issues from SQL Logs.
• Stored procedure optimization and index maintenance.
• Maintain the SQL Backups on SAN through Light Speed.
• Automated processes using SQL Server jobs and handled database objects with Enterprise Manager and Query Analyzer.
• Installed SQL 2005 and 2008 Cluster on windows cluster environment.
• Expertise in Log shipping and Replication and all standard maintenance.
• Crated SSIS Packages on production and development environment.
• Created and provided proper access use of Views to prevent unauthorized access.
• Maintenance of the database using the Database Maintenance Wizard to make some necessary changes and to keep the performance of the server at acceptable levels.
• Planned and Scheduled the Online/Offline Backups. Backed up master and system databases and restored them when necessary. Performed Log Backups and Restoration.
• Performed Capacity Monitoring, short and long-term capacity planning in collaboration with development resources, System Administrators and System Architects.
• Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Created all SQL-Backup script and blocking script.
• Experience in Sharepoint service development and configuration.
• Tuned SQL queries using Profiler, Show Plans and Execution Plans for better performance. Employed Indexing Strategies and optimized them using DBCC commands & Index Tuning Wizard.
• Partitioned a lot of tables, which had frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• Created and implemented the use the stored procedures and triggers to improve the performance and the business logic.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS)
• Created logins and maintained user permissions appropriately.

Environment: SQL Server v 2005, 2008, 2008 R2, 2000, SSIS, Win 2003, 2008 Server, Win 2003 ClusterReporting Services (SSRS), Analysis services (SSAS), MS Visual Studio 2005, ASPASP.Net, Java script

Confidential, IL

Database Administrator and Developer

Responsibilities:

• Build back-end database using programming and scripting language.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Installed a New SQL server 2005 on windows server 2003 and also upgrade 2005 from 2000.
• Create the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Monitor database environments, related jobs end procedures Database tuning & optimization Write and maintain stored procedures Work with database tools and utilities for administration and development
• Sending and Receiving the data and Images using XML technology.
• Daily support - resolve problems promptly with good solutions Backup and recovery - maintain appropriate file retention, manage rollback segments, etc
• Migration of DTS packages to the SSIS on SQL Server 2005.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication. Configured and maintained Log Shipping Environments for 2 projects.
• Managing the use of disk space, memory and connections.
• Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.
• Assisted programmers on writing queries to enable application tunning.
• Manage hardware configurations and considerations for SQL Server environment Recommend security of databases; insure that policies are adhered to when they are approved and implemented
• Documented System and Unit test cases for the modules developed.
• Remarkable learning capability and problem solving skills.
• Used Red-gate tools for Log based recovery.
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Remotely Manage SQL Server 2000.
• Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2000.

Environment: SQL Server 2008 R2, SQL Server v 2005, SSIS, SSRS, DTS, Win 2000, Win 2003 Server, SQL Back-up Red gate tool, SQL Server Business Intelligence Studio, XML

Confidential

Database Administrator and Developer

Responsibilities:

• Installing multiple instances of SQL Server 2008 R2 and database migration from SQL Server 2000 to SQL Server 2008 R2.
• Implemented SQL Server with high availability architecture using SAN.
• Migration of New SQL server 2008 R2 from SQL server 2000.
• Create and modification of the database according to the requirement.
• Data migration using BCP utility and attach/ detach database.
• Create the jobs and also maintain the jobs as daily basis as well as weekly basis.
• Implemented a Disaster Recovery plans.
• Creating snapshot replication and transactional replication in the SQL Server 2008 R2.
• Transfer bunch of tables using SSIS packages.
• Partitioned a lot of tables, which had frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• Wrote SSIS Script for data transfer and involved in the system designing.
• Installing service packs and security patches SQL Server 2005/2008 R2.
• Created logical and physical data modeling for development projects.
• Rebuild the indexes using DBCC re-index and also check index fragmentation.
• Testing QA server data with production servers.
• Check blocking process and send them vial e-mail notification.
• Actively involved in Normalization and de-normalization database.
• Capacity planning in estimating and sizing of tables.
• Provided a support for data issues and support to the application developers on application database and given appropriate solutions.
• Set up SQL Mail and crated Jobs to automate and scheduling many tasks.
• Created heavy SSIS packages on SQL Server and Reporting Services on SQL Server 2008.
• Refreshing production databases. Development of policies and procedures for ensuring their security and integrity, analyzing the queries for performance.
• As a DBA, managing 10 different production Servers and several QA Servers in multiple countries supporting several hundreds of users.
• Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written T-SQL procedures for transactions.
• Crated documentation of database design, reporting, data analysis, security, administration.

Environment: SQL Server v2008 R2, SQL Server v 2005/2000, Used 40+ database, SQL Optimizer, DTS, SQL Log Manager, Win 2003, Win 2008 R2 Server, ASP, ASP.Net, SSIS, Reporting Service, PCAnywhere

Confidential

Database Administrator

Responsibilities:

• Maintaining multiple databases for development and tuning them for performance optimization.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2000.
• Monitor Jobs, Create/modify databases and other objects as required and configure databases. helped in Supporting Huge Databases, Troubleshooting the problems.
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Design, implementation and maintenance of web based application using Microsoft NET Framework.
• Provided assistance to the Application Developer as Designing Queries.
• Data migration (import and export BCP) from text to SQL Server.
• Installed Service packs to offers number of performance and security
• Review project documents requiring database changes and implement them.
• Scheduled the jobs to run on monthly basis as well as daily basis.
• Participated in meetings with the client and team members.
• Monitor DB & SQL Server space usage and generate reports.
• Refreshing development databases. Development of policies and procedures for ensuring their security and integrity, analyzing the queries for performance.
• Documented System and Unit test cases for the modules developed.
• Remarkable learning capability and problem solving skills. Testing performance and functionality.
• Performance tuning of SQL queries and stored procedure using SQL Profiler.
• Managed database user permissions.
• Encrypted sensitive data using Encryption Features of SQL Server 2005.
• Created Dedicated Administrator Connection in SQL Server 2005.
• Intermediate knowledge of security enhancement of SQL Server 2005.
• Used Red-gate tools for Log based recovery.

Environment: SQL Server v2000, SQL Server v 2005, Supported 50+ database, ASP, ASP.Net, Crystal Reports, C#, Java Script, VB Script, Win 2000, Win 2003, Linux, ORACLE