Description
SUMMARY Over my 9 year career, I've been involved in every facet of software design/development and understand product evolution through each phase of the software development lifecycle. I provide what's necessary for projects. Peers and clients to be successful and the strategy to implement it. * Over 9 years of extensive knowledge and experience in database design, DBA & data modeling. * Broad knowledge of Information Technologies, and have successfully designed, developed and deployed, enterprise applications * Experience in supporting Very Large databases (VLDB) and troubleshooting. * Experience in ETL data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages. * Designed, Installed & configured multi node MongoDB shared cluster &replica sets on Linux and Windows platforms * Maintained security for databases (creating logins for users, roles, and assigning permissions to them). * Experience in Database Backup, Recovery and Disaster Recovery procedures. * Expert in performance tuning and handling blocking situation and dead lock situations. * Used third party Quest tools like spot light, fog light and Litespeed for backing up large databases. * Played a crucial role Migrating SQL Server 2008R2 to SQL Server 2012. * Experience in Creating Jobs (Both cron and non-cron), alerts and automating them. * Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database consistency checks using DBCC utilities and Index Tuning Wizard. * Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor. * Checking the threshold values and baselines and monitoring in performance and SCOM. * Configured and used SCOM (System Centre Operations Manager), to monitor all SQL servers * Deep knowledge in Data Modeling (logical modeling and physical modeling) using Erwin. * Experience in high availability SQL Server solutions, which include Log shipping, Replication, Mirroring and SQL Server clustering. * Experience in Database Mirroring as disaster recovery solution. * Skilled with Integration, Reporting and Analysis Services. * Profound knowledge in installation and configuring of Oracle 9i, 10g and 11g databases for OLTP, OLAP and DWH systems through silent and OUI methods. * Experience in creation of Database system, capacity and storage planning monitoring the parameters through DBCA utility and manual design. * Performed various backup batch processes ranging from Cold, hot and RMAN backup at different levels. Monitored the scheduled process of backup using CRONTAB and configured RMAN for parallelism and compression of the backup sets. * Strong experience in T-SQL Programming in Implementing & Developing Stored Procedures, Triggers, Nested * Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables, indexes and complex queries. * Experience in Tuning SQL queries and improving the performance of the Database. * Proficient in Data Modeling (Logical and Physical Design of Databases) and creating highly flexible database architecture. I've successfully delivered high quality, world-class solutions across industries, including, Healthcare, Technology, Banking, Insurance, Cloud computing & Finance. I have extensive knowledge of designing both relational (3NF) and dimensional databases (HOLAP, ROLAP), vetting functional designs, performing impact and gap analysis of existing systems. TECHNICAL TOOLS SKILL SET0 RDBMS: Oracle 12c/11g/10g, DB2, MS Access, SQL Server 2005/2008/2012. Scheduling Tools: UNIX Cron, SQL Server Agent. Data Modeling: ERStudio 11.x, ErWin 9.6, SchemaSpy, Visio, Oracle Data Modeler ETL Tools: Oracle Data Integrator 12c (ODI), Business Objects Data Integrator, Informatica Power center, SQL Loader & DTS Reporting: OBIEE OBI Publisher 11g R1 Crystal Reports Cognos and Tableau. Tools: TOAD DB Artisan Putty SQL Developer SSDT SCOM 2007 / 2012