EXPERIENCE SUMMARY:

• Having 11 years of Professional experience on Database Technologies (Database Design, Architect, Development, Administration and production Support) using SQL Server 7.0/2000/2005/2008/2008 R 2/2012/ 2014/2016.
• Have good experience on Both OLTP and OLAP using MSBI suite (SSIS, SSAS, SSRS).
• Worked extensively on Application Developments, Data Centre movement, Database upgrade projects, DB migrations (cross platform) and support projects.
• Knowledge in a Healthcare Payer Core Admin platform, such as Trizetto Facets, QNXT and Diamond.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008R 2/2008/2005/2000 on Clustered and Standby Environments.
• Experience in supporting Very Large Database (VLDB) more than 8 TB and troubleshooting problems
• Expertise in Database Backup and Recovery procedures by using native and networker backups (legato, Tivoli)
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensively worked on multi node Clustering.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor, Profiler and Extended Events to identify Dead locks, blocking, long running queries.
• Experience in high availability (clustering, Always on, replication, log shipping and mirroring)
• Experience in data modelling like physical data modelling and logical data modelling
• Migration from SQL server 2000 to 200 5 and 2000 /2005 to 200 8 and 2012 to 201 4 by using In - Place upgrade process and as well as side-by-side upgrade process.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Experience in Client/Server Connectivity and Database Consistency Checks using DBCC Utilities and DMV's and DMF's
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in opening the case to Microsoft for the environmental issue
• Experience in improving the performance by indexing, updating statistics, recompiling stored procedures and code tuning.
• 24 X 7 Production Database on-Call Support
• Experience in improving the performance by indexing, updating statistics, recompiling stored procedures and code tuning.
• Experience in Capacity Planning and tempdb optimization for better performance.
• Experience in using Dynamic management view and functions for trouble shooting the performance issues.
• Worked with Tivoli Storage for handling Production backups and Recovery.
• Experience in maintaining the SQL security per client standards.
• Experience in managing fragmentation of Indexes to achieve better query performance.
• Recognized and was included as an SME
• Received appreciations from clients and manager for prompt problem solving, implementation activities and valuable decision making activities
• Implemented High Availability and Disaster Recovery solutions using Always On, Replication and log-shipping and clustering
• Have Experience with Amazon EC2, RDS and S3 services. Migrated couple of application to AWS.
• Have strong problem solving motivations, a team working spirit, and an open mind to take extra steps to make the whole project successful.

PROFESSIONAL EXPERTISE:

DB Architect \Database consultant

• Working with client in understand business requirements and covert it to application requirement.
• Provide technical consultations and propose best solutions for user requirements.
• Work with development team for implementation of proposed solution
• Design and planning for tools selection
• Demonstrate/Create Proof of Concepts for critical issue fixes and new business requirements.
• Define enterprise-level standards (architectural, migration), platform and tool selection
• Develop strategy for data backup/recovery & enterprise level database implementation
• Provide leadership and direction to database administrators & developers.
• Implemented complicated business logics using TSQL.
• Planning for migration of databases to AWS cloud.
• AWS EC2 cloud server configurations, migrations planning and Implementations

DBA\DB\MSBI developer

• Creating files groups, tables, indexes & index partitions.
• Design/Implement ETL using SSIS, data stage.
• Design and developing reporting using SQL SSRS, Crystal and tableau.
• Good experience in all kinds database backup & restore strategies (Logical/Physical corruption).
• Good experience in database security and creating users, groups and access privileges.
• Good implementation experiences in DBCC maintenance plans and health monitoring of database instances using SQL Alerts (WMI based alerting specially).
• DBA regular activities.
• Implementation of log shipping/replications, issue troubleshooting.
• Monitoring of SQL Server jobs and troubleshoots the issues.
• Good understanding on SQL Server new features like Change Data Capture, Policy Based Management System, Database Encryption, Resource Governor, Contained Database etc...
• Good understanding on SQL Server In-Memory Database feature of SQL 2014.
• Implemented new feature like CDC, database Compression, Always-On Availability Groups on recent projects

SKILL SUMMARY:

Industries: Banking, Retailing, Energy & Utilities, Securities, Health Care and life Science.

Project Domain: Financial Management Solutions, Systems Integration, Performance Improvement, Application Development, Business Intelligence and analytics.

Hardware: IBM Mainframes, PCs, Compatibles,

Operating Systems:  Windows 2000 - 200 8R2, Linux, Unix IBM AIX

Computer Languages: Transact-SQL, C++, C, Visual Basic 4.0 - 7.0, VBScript, COBOL, Pascal, FORTRAN, PL SQL. .net Frame work, MFC

RDBMS: MS SQL Server 7.0 - 2016. ORACLE 8-12c, Sybase, MYSQL,.

No SQL: MongoDB, Cassandra, HBase

Development Tools: Visio, Erwin, Control-M, Visual Studio, TOAD

Data warehouse Reporting Tools: Business Object 6.0, Cognus6.5, SQL server 2008, Tableau, MS reporting services,

Data Warehouse ETL tools: Informatics 6.0, SSIS, Oracle Warehouse builder, PIG

Applications: Microsoft Office 97, Microsoft Office 2000-201 3

Source Code Repository: Visual SourceSafe 5.0 and 6.0, Team foundation server.

Performance and Notification Tools: Foglight, Spotlight, Microsoft operation managers, SCOM

Tracking Tools: Remedy, Clarify, HPSD, Remedy

Patching tool: SMS,HPDM

PROFESSIONAL EXPERIENCE:

Norristown, PA 

Solution Architect 

• Working as DB Architect for various Projects
• Planned for ESP and ESI application database upgrades from SQL 2008 to 201 4.
• Worked on development and Integrations of application with mobile devices.
• Imaging and scanning report integrations with Applications
• Supporting SQL server Environment of 500 Instances.
• Fine tuning the Database Settings as well as the Server Settings.
• Involved in Backup/Restore. Involved in Disaster recovery and created disaster recovery plan .Took part in Disaster Drills and took other proactive measures and received appreciation from customers.
• Health diagnostic reports design and Development.
• ETL design and Integration of Drug test data.
• ETL design and Implementation of Lab results data and costing.
• Implementations business logics on costing part of lab tests in stored procedures.
• Knowledge in a Healthcare Payer Core Admin platform, such as Trizetto Facets, QNXT and Diamond.
• Facets admin- claim processing, Insurance settlement, co-pay etc

Environment: Tableau reporting, MS SQL 2000-201 4, MySQL 5.0 - 5.7 , Windows 2003-200 8, Linux 5-7, Oracle 7.0 - 12c

Danbury, CT

Lead Consultant

• Managed technical deliverables across Databases tower (MSSQL, Oracle, MySQL, MongoDB and Sybase)
• Ensured all KMs and SLA are meet
• Provided technical escalation support to technical resources for high severity and complex technical issues (Database Engine/Application performance issues).
• Implemented technical initiatives/projects envisioned by management and tracked them till closure.
• Identified process/service improvement areas within the competency and implemented them in accounts.
• AWS migrations of IOP applications.
• Monitoring and identifying the root cause during the Application run time and also provide recommendation on the same for better performance
• Upgrade from SQL 2008r2 to 2014.
• Maintaining and supporting Transactions/Merge Replications.
• Always on configurations and migration of Finance, Reporting applications db.
• Worked on the DR strategy design with the team and implemented and validated by coordinating with DBAs, VMWARE, Network and Windows Admins.

Environment : MS SQL 2000-201 4 , Windows 2003-200 8, Mysql 5.0 – 5.7, Linux 5-7, Oracle 7.0 – 12c, MongoDB 2.3, Cassandra 2.2 MySQL 4.0- 5.2.6.

Arlington, USA

Database Consultant

• Designed and Planned the architecture for data center migration
• Provided technical consultations and proposed best solutions for user requirements.
• Validated Business Continuity and Disaster recovery plans
• Knowledge Transition and management
• Designed and Architect application using SQL server/PeopleSoft and Hyperion applications.
• Provided support and ongoing maintenance of the application modules end-to-end.
• Provided leadership to ensure the deliverables are met with high quality and efficiency.
• Data availability using transaction-replications.
• Worked on PeopleSoft environment upgrade, and tuned performance.
• Gone out of way and migrated databased as opposed by oracle.

Environment: MS SQL 2008 R2, Windows 2008, Linux 7, Oracle 12c.

San Francisco USA

DB Architect

• Worked with client to analyze business requirements and converted them to application requirement.
• Provided technical consultations and proposed best solutions to meet user requirements.
• Worked with development team to ensure implementation of the proposed solution.
• Demonstrated/Created POCs for critical issue fixes and new business requirements.
• Designed SSAS for ION Project.
• Developed Olap MDX queries.
• Validated Business Continuity and Disaster recovery plans
• Designed and architected application using SQL server/MSBI/Hadoop technologies
• Provided support and ongoing maintenance of the application modules end-to-end.

Environment: MS SQL 2000-201 2, Windows 2008, Linux 5-7, Oracle 11g.

DB Support Consultant 

• Supported Database incident management, Problem management, Change management, Technical documentations.
• Implementation of SQL log-shipping, replications and clustering
• Documented RCA for severity issues
• Patched Databases for various service pack upgrades
• Upgraded various Database version upgrades
• Responsible for configuring monitoring on SQL servers with database mails, alerts and operators.
• Responsible for Data refreshes on Test and Development Servers on a regular basis.
• Backing up master & system databases and restoring them when necessary and supported production environment.
• Monitoring Schedules for batches and also resolving incidents involving batch processes, which include system sync, card fulfillment, data loads.
• Monitoring report and schedule the reports with help of info scheduler
• Providing immediate solutions on Database and data warehouse ETL issues.
• Propagate positive teamwork across work groups & drive business results.
• Escalate problems to Developers or Subject Matter Experts during the batch-processing environment.
• Provide daily updates to Clients and Superior for review.
• Call Handling, Error Identification, Incident Management and Incident Resolution.

Environment: MS SQL 2000-201 2, Windows 2008

Minneapolis, USA

Database consultant

• Worked on Red rock project – A pharmacy applications as a database designer, Performance analyst.
• Designed and implement uniform backup recovery policy for databases and alerting on failures throughout the enterprise for 25000+ databases.
• Upgraded all HQ SQL instances from SQL 2000 to SQL 2005 .
• Upgraded all store SQL instances from SQL 2000 to SQL 2008 .
• Upgraded all HQ SQL instances from SQL 2005 to SQL 2008 .
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability
• Creation, Development and Maintenance of SSIS Packages.
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Review/test/apply all database changes to all environments including QA, Development and Production Servers.
• Installing and upgrading sql server version 2016/2014/2008/2005
• Implemented policy based management, which reduced the incidents count by 30%.
• Responsible for the Development and Debugging of Stored Procedures, User Defined Functions, Triggers and Queries.
• Designed Scripts for Reorganizing and Rebuilding Indexes and for updating statistics.
• Implemented database audits
• Implemented Resource Governor
• Implemented data compression in Target environment and saved multi Tera bytes of SAN space.

Environment: MS SQL 2000-201 2 , Windows 2003-200 8

Team lead 

• Managed the SQL databases for issues from planning to maintain and support databases.
• Designed databases for in-house application development.
• Created windows cluster and Installed sql 2005 instances.
• Implemented log-shipping, Replications
• Supporting 400 SQL instances with 1000 odd databases for over 500 applications.
• Tuned applications and optimized for performance.

IT Consultant

• Automated monitoring of the SQL server
• Monitored and improved the performance of the SQL Server.
• Troubleshooting the database issues.
• Provided on-call support
• Database migrations from SQL 7.0 to 2000 and 2005 .
• Ensured backup and restore of log and data from production to reporting database daily.
• Helped in writing database programming using VB, T-SQL, and PL/SQL.
• Ensured performance monitoring of database objects like SQL query, Stored Procedures and Views and tuned them as needed.
• Implemented Index tuning for better performance
• Managing DB Job and handling alerts
• Involved in designing the database in adding new compliance services
• Provided maintenance support and new changes of database.
• Involved in writing stored procedures, which contains all the business logic

Visual Basic Programmer 

Responsibilities:

• Developed VB Modules and required stored procedures for the project