SUMMARY:

• A self - driven professional with more than 8 years’ experience with strong capability to manage and communicate with multidisciplinary teams, make well calculated decisions and multitask with exceptional analytical and organizational abilities
• 4 years in retail industry specializing in complex business problems & “bleeding edge” project design, development, implementation and Migrations, experienced in ERP implementations of Oracle and SAP
• 7 Years of SQL SERVER DBA experience and a major implementation of MYSQL for mobile traffic
• Over 7 years working in Development, Database Administration and technical support positions
• Dynamic, self-directed Engineer focused on business requirements, data analysis, Database Administration and project management utilizing ITIL methodologies
• Experienced in installing, configuration of databases, patching, upgrading and setting up of Disaster recovery databases to ensure high availability of databases.
• Experienced in Working in NO SQL databases like Mongo DB and Couch DB.
• Published a thesis on unstructured data analysis using Map reduce
• Worked on AGILE methodology to create prototypes for demonstrating database features
• Experienced in setting up of Backup and maintenance plans across diverse databases
• Experienced in Schema design and Database architectural design and helped in effectively coordinating with diverse vendors for deployment, support and maintenance of databases.
• Worked on Nutanix and V RACK based hyper converged infrastructure and software based storage systems
• Implemented replication and setup clustering in Oracle, My SQL and SQL Server databases
• Experienced in supporting databases 24*7 during the holiday season and monitored databases for long running jobs.
• Tuned queries to increase the performance of databases by providing recommendations to developers
• Skilled at eliciting holistic Business Requirements (system, process & people) and identifying, managing conflicting requirements
• Adept at analyzing data flow and identifying root cause analysis for problems
• Experienced in implementing SOX compliance and coordinated internal audits across different projects
• Proven results-oriented professional leading projects beyond initial implementation to stable sustainment
• Experienced in moving databases from Client Server Architecture to Cloud
• Programming Languages: PHP, Java, PL-SQL, Python, R, shell scripting, CSS, HTML, JavaScript, JSP, Visual Sales Force
• Database Systems: Oracle 9i, oracle 10g(certified)/ oracle 11g/oracle 12c, MySQL, MS-SQL Server
• Plat Forms: Linux, Microsoft OS, Kali Linux, Fedora
• Cloud Technologies: AWS certified Solution Architect and Docker
• Other Tools and Technologies: Robo FTP, tumbleweed, SQL developer, BR Tools, Visual Studio, MS Project, Net Beans, Eclipse, Oracle OEM, Para soft Virtualizer, Tableau and SOA Test
• A strong problem solver with hands on experience applying extensive business knowledge
• Energetic, self-motivated individual always seeking new challenges

TECHNICAL SKILLS:

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 11.x, Windows, Sun Solaris 9.0/10.0

Data Bases: Oracle, MYSQL, Sybase basics, Mongo DB and Microsoft SQL server2000-2012.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Tools: SAP,RAC, OEM Grid Control, Informatica, Exadata, Golden gate, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, Ms Project,MS Office,MS Visio,SQLNET, ODBC, Export/Import, Data pump, Dataguard, VRACK, VMware and CronTab.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH & ADDM.

Terminal Emulation: Toad, Putty, Telnet, FTP, MobaXterm& PL/SQL.

PROFESSIONAL EXPERIENCE:

Application Migration Engineer/ DBA

Confidential, Charlotte, NC

Responsibilities:

• Created plans to migrate the existing databases and application to an internal cloud based technology
• Analyzed data and migrated certain objects from physical databases to internal cloud based databases
• Prepared documentations for new batch jobs in SQL SERVER 20014/2016 database
• Created plans to upgrade database from MS SQL Server 2014 to 2016 and tested the feasibility of moving the unused data chunk to secured AWS buckets.
• Initiated the migration from physical servers to AWS/Azure cloud infrastructure in the Datacenter including setting up web server, app server and SQL servers.
• Worked with employees to setup SQL Server clients and helped them to add the databases for querying.
• Installed, configured and administered SQL Server and 2012(Standalone and Cluster) on Windows Server 2012 R2.
• Monitored databases for performance and helped developers choose optimal plans
• Scheduled and monitored jobs using Autosys for database related transformations in infromatica
• Created backup plans for objects specific to certain applications and provided support during monthly maintenance and patching of databases.

Confidential , Richfield, MN

Project DBA

Responsibilities:

• Installation & Configuration of MS SQL Server 2005 /2008/2008 R2.
• Upgradation of Database from SQL Server 2005 to 2008.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Created, administered & maintained SQL Server Databases (Production, Test and Train Env.) for various groups such as user etc., and ensured the Availability of the Database Server in a 24X7 Environment.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Provided support during holiday seasons which generates 75% of their sales
• Involved in virtualization of database components for the POS system eliminating the cost of SQL Server DB refresh
• Have an extensive knowledge of implementing Point OF Sales (POS) systems and the associated payment Gateways
• Responsible for Migrating 40 tb of data between two oracle 11g databases across platforms
• Involved in the creation, deployment, documentation and maintenance of database deliverables
• Created plans to sync the disaster recovery oracle databases in a Round Robin fashion to maintain High Availability
• Created scripts to generate reports for database growth and automatic import and export of schemas
• Implemented the most Complex database in MYSQL on ACFS mount point on an ORACLE RAC cluster, this was later made as the principal database for white label an application for registering mobile phones all over US
• Developed plans for upgrades of MS-SQL Server 2000 -2008, oracle 12c and documented it for future reference
• Created pl/sql procedures to extract data from various sources saving cost of $680 per day
• Created Backup and capacity planning for the holiday season for 600 SQL Server Databases in store
• Set up multiple publisher and Single subscriber replication across Point of Sale systems in SQL Server
• User SQL Server Profiler and activity monitor to create optimized query recommendations for developers
• Tuned queries using the AWR/ASH reports to increase performance and reduced timelines of data access and saved 30 million during holiday season
• Analyzed the feasibility to set up Always ON availability group for High Availability and Disaster Recovery
• Performed database migration using the ASM attach and detach mechanism to reduce the actual down time
• Migrated around 30TB of Storage disks from one storage box to another
• Create Disaster recovery environments across the servers to ensure proper backup exists among the servers
• Patched oracle OEM clients with minimal down time, created and synced disaster recovery databases
• Extensively used database export and import to migrate data across the servers, i.e. different OS
• Performed basic level of performance monitoring and helped to achieve zero down time during the holiday season
• Had an exposure about the AWS cloud and how data could be migrated to the cloud
• Created oracle profiles and roles to restrict the user s activity beyond a certain point as a part of SOX compliance

Database Consultant/Project coordinator

Confidential, McCook, IL

Responsibilities:

• Migrated SAP from DB2 database to Oracle 11g, Oracle 10g and then to MS SQL Server 2008 database using SAP OSDB migration technique
• Gathered and documented business requirement created plans for communication across multiple stake holders
• Created Work breakdown structure, and documents, to establish technical requirements
• Lead the interface between Vendor and design team during product development and roll-out including design & technical collaboration at all stages
• Created User accounts, Roles and granted required access permissions and privileges to the database based on the Applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Scheduled backups using Maintenance tasks and scheduled daily jobs for monitoring db growth in MS SQL SERVER, reorganized databases at regular intervals to reduce space
• Created replication as a solution for backup in SQL SERVER and setup mirrors to reduce the db restoration time
• Tuned queries in SQL Server based on the recommendations provided by Database Tuning Advisor
• Highly involved in database capacity planning and used linear regression to predict growth of Databases in SQL SERVER and help avoid issues relating to space
• Resolved issues pertaining to Temp SQL SERVER database and helped teams to create suitable data quality checks
• Created a mechanism to archive databases in SQL Server to reduce the storage
• Performed automated backups and scheduling using scripting in ORACLE and SQL SERVER .
• Created tns entries to be pushed to global offices for applications to connect to oracle 10g and oracle 11g database.
• Created backup plans for oracle 11g and oracle 10g databases across an ambiguous environment
• Involved in parallel migrations across databases from DB2-> Oracle-> SQL Server

Database Administrator

Confidential

Responsibilities:

• Migrated Uni-trust Oracle 10g DB to Atkore holdings SQL Server DB saving operational cost of 20TB per annum
• Developed and implemented an SAP archive strategy to reduce the size of the database to 3TB from 20TB
• Installed MS SQL Server 2005, 2008 R2, updating with latest service packs and security patches.
• Managed Databases spread across multiple servers in Production, Development, staging & testing Environments.
• Worked extensive with database design team and development team for database design and implementation, used Visio for database design and SQL Server 2008 for development.
• Implemented the Data Partitioning for large tables in SQL Server 2008.
• Created custom log-shipping to manage Disaster Recovery and Production Support restores
• Scheduling the DBCC commands to run daily, weekly basis. Developed automated tasks for daily, weekly and monthly
• Database maintenance such as database backup, database integrity verification
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Worked file and file group Backup/Restore.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in database storage and capacity planning.
• Daily performance tuning and troubleshooting assignments, including SQL performance, checking error logs, system event logs and SQL Server logs for unusual events.
• Work closely and regularly with Management, Business Analysts and Infrastructure Teams, and updating with regular reports and status updates.
• Solving the Bugs Reflected by the Testing team and evaluated data storage considerations to store databases and t-logs

Database Administrator/ Infrastructure support

Confidential

Responsibilities:

• Created 25 instances of production databases in Oracle and SQL Server
• Performed SAP Data Refreshes, from production to QA using Shadow imaging
• Customized reports to suit the questions asked by stake holders and served as an internally ITIL SPOC
• Implemented SOX compliance on 100 instances of oracle and SQL Server databases and documentation for audits
• Developed a strategy to decrease the downtime of SAP application from 8hrs to 10 minutes
• Scheduled export and import cron jobs and monitored databases for optimal performance
• Perform Daily Monitoring of Oracle Instances, users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Experience in MS SQLSERVER 2000 and 2005 including system installation and upgrade, backup and recovery, data server migration, database maintenance and support, release management, troubleshooting, performance tuning, developer and third party product support, configuration and support of DTS and SSIS jobs, SQL Server Agent jobs and maintenance plans.
• Experience with the SQL Server Log Shipping, clustering, replication and database mirroring features.
• Experience with installing and supporting SQL Server 2000, 2005 and 2008, particularly with features such as Integration Services, Reporting Services and Analysis Services.
• Familiarity with SQL, Transact-SQL and troubleshooting queries and stored procedures.
• Experience creating documentation of installation procedures, monitoring procedures, security policies, configuration changes, migration procedures, and best practices for development teams.
• Experience in database backup\recovery. Handling tickets / requests
• Monitoring and maintaining SLA requirements by the team members. Planned Backup/Restoration Strategy for 24x7 operation support
• Suggesting patches/upgrades to maintain security level
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to Users
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc.,
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Created scripts for secure banking transactions between Confidential Confidential, Confidential