Madhav Narayan. T. K

****, ******* *****, #*, ******* CA 94002

Email: ac0sc0@r.postjobfree.com

Ph:708-***-****

Applied Skills:

A self-driven professional with more than 7 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

3 Years of SQL SERVER DBA experience and a major implementation of MYSQL for mobile traffic

Over 6 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 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.

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 using SQL Sentry

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

Education:

Masters in Information Technology, University of North Carolina Charlotte: Dec 2016

Bachelors in Computer Science and Engineering, Anna University: May 2008

Professional Experience:

Application Migration Engineer, Bank Of America, Charlotte, NC Feb 2017- Present

Created plans to migrate the existing oracle 11g databases and application to an internal cloud based technology

Analyzed data and migrated certain objects from physical oracle 11g databases to internal cloud based oracle 12c databases

Prepared documentations for new batch jobs in SQL SERVER 2005 database

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.

Tata Consultancy Services Ltd Dec 2008 - March 2015

Project DBA at Best Buy INC, Richfield, MN May 2013 - March 2015

Installation & Configuration of MS SQL Server 2005 /2008/2008R2.

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

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 mountpoint 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

Tuned queries using the AWR/ASH reports to increase performance and reduced timelines of data access and saved 30 million during holiday season

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 at EMD Progress rail, McCook, IL Dec 2012 - May 2013

Migrated SAP from DB2 database to Oracle 11g, Oracle 10g 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.

Performed automated backups and scheduling using scripting.

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

Coordinated project team of 50 across locations in Australia, USA and India for migration and software development

Database Administrator at At-Kore Guildford Sydney, Australia Dec 2011 - Dec 2012

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 at EMD at Offshore India Dec 2008 - Dec 2011

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 EMD JP Morgan, Ceridian and Bank OF Montreal

Contact this candidate