SUMMARY

• 8+ years of IT experience in Database Administration and System Administration in various domains like Finance, Insurance and Healthcare
• Expert in installation, configuration and maintenance of MSSQLServer2012/2008 R 2/2008/2005/2000 in stand alone and clustered servers.
• Highly experienced in investigating and applying necessary SQL Server database servicepacks,Hot fixes and Security Patches.
• Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in different environments
• Experience in installing SQL 2012.
• Good knowledge in creating SQL objects like Databases,tables, views, stored procedures, Indexes, Triggers, User defined data types, cursors and Functions.
• Experience in T - SQL programming skills.
• Extensive experience in Migration from Oracle to SQL.
• Experience with Veritas Net backup
• Coordinated in Virutal center Upgrade.
• Experience with IIS Configuration for 2005 SSRS
• Handled up to 10+TB of data
• Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, clustering, Replication and SRDF).
• Hands on experience in troubleshooting Database/data Issues
• Experience in Performance Tuning for slow/long running stored procedures and server level tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Worked extensively in clustered environment (active / passive) to further increase scalability and stability of business critical systems.
• Experience in writing and debugging Stored Procedures and Triggers.
• Experience in implementing different types of Replication Models like Snapshot, Merge and transactional.
• Expert in designing disaster recovery model for corporate databases. For Ex: Redgate and Erwin
• Expert in utilizing different Monitoring tools including third party tools.
• 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.
• Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.
• Experience in setting Database E-mail for notifications
• Experience in SQL Server Reporting Services (SSRS).
• Experience in creating data models and deploying to Report manager for developing Ad-hoc reports.
• Experience in working with remote teams
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Experience in Installation of SSRS 2005/2008 .Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
• Creating and configuring Service Broker, End Points, Queues, Message types and Remote Binding
• Experience in creating SSL Certificates.
• Good experience with the entire phases of Software Development Life Cycle (SDLC) that include analysis, design, development, testing and deployment.
• Experience working with TWS job scheduling.
• Experience in creating STAR SCHEMA design and different data models
• Experience in installation of Oracle 10G and Unix scripting
• Experience in using Confidential tool for queue monitoring
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS.
• 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

RDBMS: MS SQL SERVER 2000/2005/2008/2012 , Oracle, Ms Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSAS

Programming Languages: SQL, TSQL, HTML, XML, PL/SQL.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Linux, MS-DOS.

Utility Tools: MS Office, MS Project, Confidential Service Manager

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2008 and 2008 R2 Servers.
• Managed 2005 SQL Servers
• Upgraded SQL Server 2000/ 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.

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential, Morris Plains, NJ

SQL Server DBA / BI Developer

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Configured CDC on Replicated Database.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Developed ER Diagrams using Visio 2000. Designed Star and Snowflake data model.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Developed Cubes using SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase,DB2 UDB

Confidential, Memphis, TN

SQL Server DBA/ Developer

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005/2008 on windows 2000/2003/2008 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Scheduling SSIS jobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.
• Involved in Health Check process for database and monthly auditing of the servers.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Table and Page level compression and Resource Governor.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005/2008, which includes in-place, side-by-side and standalone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked on different DB replication techniques.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Designed database standards as per HIPAA and PHI specifics.
• Participated in Disaster Recovery.
• Participated in DR installation and troubleshooting(Mirroring, Logs hipping and High availability Cluster
• Experience in T-SQL and PL-SQL
• Optimized the Disk space for performance using RAID and SAN.
• Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.
• Handling the RFC s and work orders assigned to me as part of daily responsibilities.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Managing security roles in SQL Suite.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, DTSxChange, MSAccess, VMware ESX, Windows 2000/2003/2008 Servers, Litespeed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential, WI

SQL Server DBA/Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems.
• Created database objects like tables, stored procedures, views, Triggers, Rules, Defaults, User defined data types and functions in SQL Server 2005.
• Designing and Optimizing all the SSIS packages
• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
• Created Backups Strategies for databases and automated the process.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. Removed fragmentation from indexes.
• Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
• Created Transactional replication, pull subscription and defined edition to transfer data from branch to head office and vice versa.
• Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
• Replicated SQL servers handling thousands of logins per day with 24/7 uptime to service clients.
• Involved in Management of clustered database servers.
• Ensured constraints and writing triggers to apply business rules. Performance Tuning, backing up and restoring user databases.
• Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS
• Created different user level groups and assigned appropriate permission level to the database. This made sure that only right person with enough authority would be able to see the information.
• Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.

Environment: SQL Server 2005/2000, Oracle 9i/10g, MS Access, T-SQL, SSIS, SSRS, SSAS, Windows Server 2000/2003

Confidential

Jr. SQL Server DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Supported clustering and replication for servers.
• Responsible for Tuning the Tuxedo/Application server to boost performance
• Generated database SQL scripts and deployed databases including installation and configuration
• Created Reports Using MS Reporting Services.
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Maintained cluster servers to provide high availability.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Migrated few objects from SQL Server 2000 to SQL Server 2005
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, Oracle, MS Access, Windows 2000/NT/XP, MS Reporting Services, DB2, Microsoft Visual Source safe.