SUMMARY:

• A Microsoft certified professional with 15+ years of IT experience (15+ years US project experience)as DBA, Project developer, System administration and DBA Team Lead as given below.
• Very proficient in designing Logical and Physical model of database and Reverse engineering using ERWIN and Power Designer Tool.
• Experience in data migration from Sybase/MS AcMS Access/Fox Pro/XL/Text files to MS SQL Server 2000/2005/2008/2012/2014.
• Very proficient in creating of Data Transformation Service packages in SQL Server 2000/2005/2008/2012/2014.
• Installed and configured MS SQL Server in Windows 2000/2003/2008/2012/2014 Cluster.
• Extensively used SQL Server Profiler, Index Tuning Wizard and Show plan and DMVs to optimize the SQL Server performance.
• Acceptance testing, Production Implementation, Parallel run, Post Implementation, Maintenance, Production support, Documentation and User .

TECHNICAL SKILLS:

RDBMS: SQL Server 6.5, 7.0,2000, 2005 and 2008, 2012, 2014 and 2016. Oracle 12c, 11gR1/R2/10g/9i, .Sybase 11.x & 12.x,Oracle 8i,MySQL 5.7.5 Unify, MS Access Dbase, Paradox and Fox Pro.

Languages: C, COBOL, UNIX Shell Script, VB Script, XML, HTML TSQL, PL/SQL, Vb6 and ASP.

OS: AIX UNIX, ScoUNIX, and Windows 2000, 2003,2008 and 2012 R2.

Reporting Tools: SQL Server Reporting Service 2005,2008,2012,2014 and 2016and Crystal Reports 7.0/8.0/8.5

Platform/Tools used: SQL*Plus, SQL*Loader, PL/SQL, stored procedures, triggers, Oracle Enterprise Manager, SQL Server Management Studio, Microsoft desktop applications - Word, Excel, Access, Project, Visio, Erwin 4.1 & 3.5.2, Log Explorer and Windows Script, MS SharePoint 2003 and SQL Compare.

PROFESSIONAL EXPERIENCE:

SQL Server Tech Lead

Confidential, Battle Creek MI

Responsibilities:

• Installing and configuring SQL Server 2014 and 2016 in Windows cluster.
• Database Design for Promo Simulator, CAP and Security authentication application.
• Created stored procedures and jobs to pull data from Data ware houses of all above said applications.
• The true tracker data from three applications were updated back multi data warehouses.
• Created stored procedures and jobs to sendback tracker tomulti data warehouses.
• Designing and creating backups & recovery strategy for all production servers.
• Performance tuning of SQL Server, Database Indexes, Stored procedures and optimizing user queries.
• Handling SQL Server Database Administration support activities including database storage file, maintenance, backup and recovery of databases, export and import of databases, client / server database connectivity, database security and user privileges.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced
• Replication, Real Application Clusters, Oracle Standby Servers.
• Performance tuning and monitoring of databases, data archiving and purging, troubleshooting and management of production databases and disk space management.
• Analyzing developer coded stored procedures, Views, Functions and modify the business logics in the code and introduce new features in the code for better performance.
• Deploying/Rollout of new versions of application code to QA, UAT and Production servers.
• Reviewing and implementing backup and recovery procedure as per best practices whenever needed.
• Developing Stored Procedures, View and functions, SQL Server Jobs and SSIS packages for three applications.

Environment: SQL Server 2012/2014EP, SSIS and IBMVM Servers.

SQL Server Specialist

Confidential

Responsibilities:

• Installing and configuring SQL Server 2008,2012 and 2014 in Windows cluster.
• Configured All ways on High Availability feature in SQL Server 2012 and SQL Server 2014.
• Configuring Log shipping, Replication, Database Mirroring as a HA solutions in many production servers.
• Migrated databases from SQL Server 2000 and 2012 in VM environment.
• Upgrading of SQL server software from 2000, 2012 and 2014.
• Designing and creating backups & recovery strategy for all production servers.
• Performance tuning of SQL Server, Database Indexes, Stored procedures and optimizing user queries.
• Handling SQL Server Database Administration support activities including database storage file, maintenance, backup and recovery of databases, export and import of databases, client / server database connectivity, database security and user privileges.
• Performance tuning and monitoring of databases, data archiving and purging, troubleshooting and management of production databases and disk space management.
• Analyzing developer coded stored procedures, Views, Functions and modify the business logics in the code and introduce new features in the code for better performance.
• Deploying/Rollout of new versions of application software in all clients production servers.
• Reviewing and implementing backup and recovery procedure as per best practices whenever needed.
• Implemented, configured and supported Alwayson feature in QA and Production servers.
• Two new MySQL Server database was created to store medical transcription application data for small hospital clients and Independent doctor’s office. These applications were very user friendly and cost effective.
• Providing database solutions to MModal Legacy Clients.

Environment: SQL Server 2005/2008/2012/2014 EP, MYSQL, .NET, Erwin 4.1 and SQL Compare, SSI and Reporting Service (SSRS), IBM HP Servers/VM Servers. Oracle 11g R2 RAC, ASM, OEL, HP-UX, MS Windows, OEM Grid Control, TOAD 10.0.,Exadata, Oracle EBS 11i/12.1.

SQL Server DBA Lead

Confidential

Responsibilities:

• Current Legacy Dbase Licensing, Consumer Affairs and Enforcement data needs to be converted into new integrated LACE system. Erwin design tool was used to prepare and maintain the new LACE database.
• New intermediate database have been designed in SQLServer 2005 to transfer data from multiple data sources like Dbase, Paradox, Access 97, XL, Text files etc.
• SQL Server Management Studio (SSMS) was used to manage multiple SQL Servers.
• Erwin 4.1 data modeling tool was used to design conceptual, Logical and Physical database design.
• I have carried out a data mining in different data source like Paradox, DBASE III, Access 97, 2000, Main frame generated text file data, and XL files etc to group and consolidate data for conversion.
• Many new DTS packages (SSIS) have been created for nightly processing jobs and to send alters to users.
• I have captured all data changes request to Production and better managed CDC control.
• Database Server Tuning advisor was used to analyze workload files and queries to better to Indexes.
• SQL Server Profiler tool was used to capture trace files to analyze long running stored procedures and queries.
• More than 100 views and stored procedures were optimized to execute less than 5 seconds, which was previously executing more than 5 minutes.
• SQLCMD line utility was used to load bulk copy financial data from main frame text files.
• SQL Compare tool was used to move all development server objects to System Test and Production servers.
• Many new Triggers have been created to maintain data integrity.
• SQL Server 2008 reporting server (SSRS) was implemented to create MIS reports.
• Using Database Maintenance Plan new backup strategy has been implemented in all SQL Servers.
• I have lead and supported 10 members of development Team for all application development, System Testing and production rollouts.

Environment: IBM and HP Servers, SQL Server 2005/2008 EP, .NET, Access - 2000 and Dbase III, Erwin 4.1 and SQL Compare, SSI and Reporting Service (SSRS).

SQL Server DBA Lead

Confidential, DALLAS, TX

Responsibilities:

• Current Revenue Management system was migrated from Access 2000 to SQL Server 2005. SQL Server 2005 integration service was extensively used for data migration.
• SQL Server 2005 Management Studio was used to create database maintenance plan, User accounts, Rolls and Jobs scheduling.
• SQL Server Configuration Manager (SSCM) was used to configure all service accounts and surface area configuration.
• As per new business requirement and single integrated revenue management system was designed for Travel Industry (Airlines, Rail and Cruise).
• Actively participated as database design team member. More than three hundred tables were designed for the application.
• Installing and configuring SQL Server 2005.
• New packages have been created to upload daily transaction files, supplied by online reservation system for analysis.
• Many new Triggers have been created to maintain data integrity and move/copy data to historical tables.
• Installed and configured Windows 2003 Microsoft Clustering for production servers.
• I have lead and supported 15 members of development Team for all application development, System Testing and production rollouts and production support.

Environment: DELL Servers, SQL Server 2005 EP, .NET.

Production DBA and Database Designer

Confidential, IRVINE, CA

Responsibilities:

• Served as production DBA and database designer for the real estate application system. Redesigning the current application for the new business requirement.
• Designed a new reporting database to reduce the load on production server. New packages have been created to transfer data from production to reporting server.
• SQL Server Enterprise Manager Tool was extensively used to manage databases, Scheduling Jobs, create database maintenance plan and monitor server logs etc.
• Replication has been configured to replicate data from production server to five different branch offices in US.
• I have captured all data changes request to Production and better managed CDC control.
• Query Analyzer tool was used to analyze T-SQL queries to analyze queries execution plan and to create Views, Stored Procedures and functions.
• Database tuning task have been carried over in production server.
• Implemented Log shipping for production servers.
• Using Database Maintenance Plan new backup strategy has been implemented in all SQL Servers.
• SQL Server 2000 reporting server was implemented to create MIS reports.
• Installed and configured Windows 2000 Microsoft Clustering for production servers.
• I have lead and supported 10 members of development Team for all application development, System Testing and production rollouts.

Environment: DELL Servers, SQL Server 2000 EP, .NET and MS SharePoint 2003

Production DBA and Database Designer

Confidential, IRVING, TX

Responsibilities:

• Served as production DBA for Consumer DSL, Business DSL, Change Order DSL, Security Products and Fiber DSL applications.
• Key player in design phase of databases for all above said applications.
• Many new Database and Application level Alert Jobs are coded in production servers using SQL server and Active X scripts.
• To prevent Web Site Hacking, new Alert Database and Tools were created in production server, which will automatically turn off the application; when certain threshold is reached.
• New Reporting database was designed to update online orders for all five applications. The reporting website is capable of producing various data analysis reports from the reporting Db. The reporting db is updated every 15 minutes by consolidated data from five production servers.
• Implemented Log shipping for production servers.
• Installed and configured Windows 2000, 2003for Microsoft Clusteringserversand Archive database was designed to store historical data.
• Many new Triggers, SPs, Views and UDF have been created to maintain data integrity and move/copy data to historical tables.
• Using Database Maintenance Plan new backup strategy has been implemented in all SQL Servers.
• Supported more than 25 application developers both in on-site and off-site.

Environment: Compaq and HP Servers, SQL Server 2000 EP, .NET ASP and COM.

DBA, Database Designer

Confidential, Network, VA

Responsibilities:

• As a SQL Server DBA New Central Subscriber Replication Model was designed and implemented to replicate data between three different locations in US.
• New Logical and Physical database design was created. Data was migrated from FoxPro database to SQL Server 2000.
• Database design mapping was done between SQL Server and FoxPro databases.
• DTS Packages were created to transfer daily transactions from FoxPro to SQL Server.
• SQL Server Profiler tool was used to capture time consuming stored procedures, queries.
• New Stored Procedures were coded for system monitoring Jobs like blocking users, find the Objects created/Deleted, Trace the server and Database configuration change and to filter the Open Transitions.
• As part of Job automation process, Windows 2000 Script tool was used define SQL Server Job System.
• Database user queries were tuned for better performance.
• New backup schedules and recovery procedures were created and tested for all Production and Development Servers.
• SQL Server upgrades from 7.0 to 2000 and applying service packs to all servers.

Environment: Compaq Server, SQL Server 2000, 7.0, 6.5, Fox Pro & .Net ASP

DBA, Database Designer & Data Modular

Confidential

Responsibilities:

• As a SQL Server DBA, Customers new business model was completely studied and logical, Physical database model was prepared using Erwin 4.x tool.
• Database design mapping was done between present L&I database and new EIRD database.
• New interface databases were designed to transfer data between EIRD database and Mainframe.
• Archive database was designed to keep history of updated records.
• Responsible for creation of new database, SP’s, views and functions.
• New Scripts, Stored Procedures were coded to transfer data from Sybase Database to SQL Server 2000.
• DTS Packages were created to Transfer Data from OLTP to EIRD DB.
• All database scripts were stored in MS Visual Source safe for version control.
• New Stored Procedures were created to return data set as XML document.

Environment: Compaq Server and SQL Server 2000. & .Net ASP

DBA, Database Designer & Data Modular

Confidential, NJ

Responsibilities:

• Confidential Corporation HR Database was converted from Sybase to SQL Server 2000.
• Database Design mapping was done between Sybase and SQL Server 2000 and data was migrated.
• Confidential Wireless Sybase DB is converted to Oracles 8i.
• 2 GB of data was recovered from Transaction Log of 20 GB of damaged SQL 2000 Database using Log Explorer Tool.
• Conversion scripts, new stored procedures and views were coded in all Databases.
• Along with backup schedule New Jobs and Alerts were created.
• Creating and Scheduling Jobs using Maestro tool in Aix UNIX.
• New SQL server packages were created to transfer data from DB2 database.
• New Stored Procedures were created to Extract data from OLTP databases to transform data OLAP servers; this job takes care of data scrubbing of warehouse servers.
• Conversion documents were prepared.
• Responsible for Analysis and Design of various HR and conversion Reports using Crystal Reports 8.0

Environment: IBM RS6000, Compaq Servers, Sybase, Oracle & SQL Server 2000.

SQL Server DBA

Confidential, New York, NY

Responsibilities:

• Logical and Physical database model was designed and implemented.
• Installed and Configured MS SQL Server 2000 Cluster.
• SQL Server 7.0 Database was migrated to SQL Server 2000 with design change.
• Played a Key role in Y2K data conversion project for the above said system.
• In March - 2000 the system was completely redesigned to support new business needs.
• Created more than 100 jobs in different servers for purging and moving data.
• Replication was implemented for production databases.
• Erwin 3.2 software was used as System design Tool
• Database production roll out scripts for various banks are also created.

Environment: Compaq Pentium - Servers - SQL Server 7.0 and SQL Server 2000.