SUMMARY

• 8+ years of experience in Database Administration and Development for very large and complex databases inSQLServer 2014/2012 /2008 R 2/2008/2005/2000 comprising OLTP and OLAP environments.
• Expertise in installing MSSQLServer 2014/2012 2008 R2, 2008, 2005 and 2000, updating with latest service packs, hot fixes and security patches.
• Dexterity in implementing different types of High Availability & Disaster Recovery scenarios like Replication models (Snapshot, transactional), Log Shipping, Database Mirroring and Clustering.
• Migration ofSQLServer 2000 databases intoSQLServer 2005 andSQLServer 2008 as well asSQLserver 2005 intoSQLserver2008.
• Experience in working withSQLServer 32 bit and 64 bit environments.
• Administered multipleSQLInstances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Proficient inSQLServer 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented the newSQLServer 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try - Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, Database Tuning Advisor, SQLCMD
• ConfiguredSQLMaintenance Jobs in 2005/2008 environments.
• Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Involved in Risk Management and Solved many Issues on Security and Logins an
• 24 X 7 Production Database on Call Support.
• Good experience in configuring and troubleshooting IIS and XML.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQLServer 2012/2008 R2/2008/2005, MS Access.

Programming Languages: T-SQL, PL/SQL, C, C++, HTML, PHP, JSP

Software/Databases: MSSQLServer 2014/2012/2008 R 2/2008/2005/2000 , MSSQLServer Reporting Services 2008/2005 (SSRS), MSSQLServer Analysis Services 2008/2005(SSAS), MSSQLServer Integration Services 2005 (SSIS), OLTP, OLAP,SQLServer Management studio (SSMS),SQLQuery Analyzer,SQLProfiler, Bulk Copy Program (BCP),SQLIgnite

Operating Systems: Linux, Unix, Windows 98/XP/NT/Vista/windows7/Windows Server 2003/ Windows Server 2008, MAC.

IDE & BI Tools: SQLServer BI Development Studio (BIDS), MS Visual Studio 2008/2005

Data modeling Tools: Erwin 7.2/4.5, MS Visio 2003/2007

Design Methodology: Unified Modeling Language 1.1 using Rational Rose

Reporting Tools: SQLserver Reporting Services(SSRS),Crystal Reports

ETL Tools: SQLServer Integration Services(SSIS),Data Transformation Services (DTS),SQLServer Integration Services (SSIS), Import Export Data, Bulk Insert

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Database Administrator

Responsibilities:

• As a Production and development supportDBAresponsible for maintaining 150SQLServers out of which 100 servers are production servers in which 30 were mission critical and 70 were business critical servers, remaining test and development servers.
• InstalledSQLServer 2008 R2 andSQLServer 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for ACTIVE/ACTIVE and Active/PassiveSQLServer 64 bit environment
• ManagedSQLServers in 32/64 bit Clustered environments
• Implemented Database Mirroring onSQLServer 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively usedSQLPROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Worked extensively withSQLServer DMV's for resolving performance bottlenecks
• Worked extensively on Windows Performance for I/O bottlenecks
• Upgraded server from MSSQLServer 2005 to MSSQLServer 2008
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server toSQLServers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )

Environment: MSSQLServer 2005/2008 / 2008 R2/2012, Windows Server 2008, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication.

Confidential, Tampa, FL

SQL server DBA

Responsibilities:

• Managed All Production, Development and QA Environments running MSSQL Server.
• Involved in Migration of Production Database Servers fromSQL Server 2000 to SQLServer 2005.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Worked with Off-shore teams for builds and releases.
• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
• Implemented Database mirroring for High Availability.
• Maintained various databases for Production and Testing usingSQLServer 2005.
• Used AllFusion ERWIN to deploy any changes to the database and objects from test to production.
• Worked withServer Profiler and Perfmon
• Involved in Monitoring Performance of different production servers.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and Optimization of Stored Procedures and Queries.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance ofServer which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in creating reports usingSQL Server Reporting Services (SSRS) as per the requirement.
• Migrated DTS packages to SSIS packages.
• Involved in Migration of Reporting Servers fromSQLServer 2000 toSQLServer 2005.
• Managing schema objects such as tables, views, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Administering the MS SQLServer 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.

Environment: SQL Server 2005 / 2000, SSRS, Windows 2007

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Responsible for providing 24x7 fast pacedDBAsupport for production, staging and testing environment.
• Responsible for setting up and maintaining several staging, qa, testing and production environments.
• Creating and maintaining access for these environments to different type of users.
• Having experience in Project management, end to end planning, Coordination, implementation and setup of Database Servers.
• Developing reports and email alerts using SSIS and SSRS for care managers of services to be provided.
• Created and scheduled member authorization process and generating these reports.
• Involved in performance tuning of the databases, troubleshooting, managing the use of disk space (capacity planning), memory and connections.
• Responsible for creating SSIS packages to run remittance process (to process claims to be provided to the providers).
• Responsible for scheduling and monitoringSQLserver agent jobs and Database Maintenance process in production and internal environment.
• Configured and maintained Transactional replication.
• Captured and analyzed the long running stored procedures usingSQLProfiler and tuned the same to improve application performance.
• Used Execution Plan,SQLProfiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created various complex T-SQLQueries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Data center migration and also upgradedSQLServers from 2005 to 2008 / 2008 R2.
• Experience on working in Agile/Scrum environments.

Environment: MSSQLServer 2005/2008 / 2008 R2/2012, Windows Server 2008, SSIS, SSRS.

Confidential, Piscataway, NJ

SQLAdministrator

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005/2008. Planning the location of data, indexes, and Transaction log files on the disk.
• Install and configure SQL Server 2005/2008 on the server and client machines, provide connections and manage databases.
• Assisted in Upgrading SQL Server 2000, 2005 databases to SQL Server 2008.
• Planning, Implementing and troubleshooting Replication.
• Involved in planning and monitoring Log Shipping.
• Involved in SQL Server Hardening.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, network latency and Resolve locking and blocking issues.
• Configured up to 32 GB of memory.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard for optimal query performance.
• Implemented Database Mirroring as part of disaster recovery plan.
• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• Maintaining both DEV and PRODUCTION Servers in sync.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.

Environment: MS SQL Server 2000, 2005, 2008, Windows Server 2003, Windows 2000-Advanced server NT, XML.

Confidential

MS SQL Server DBA/Analyst Programmer

Responsibilities:

• Installed SQL Server on Windows 2000 Server.
• Involved in the Analysis and Design
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Backup recovery schedules, Backup scripts.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Data Migration from legacy to master screen using VT Script.
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.
• Environment:
• MS SQL Server 2000/7.0, T-SQL, DTS, Microsoft VC++, Windows 2003 Server, Compuware QA Load test Ramco virtual Works and Crystal reports 8.0.

Environment: MS SQL Server 2000/7.0, T-SQL, DTS, Microsoft VC++, Windows 2003 Server, Compuware QA Load test Ramco virtual Works and Crystal reports 8.0.