SUMMARY

• 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
• 5 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 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
• 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

PROFESSIONAL EXPERIENCE

Application Migration Engineer

Confidential, Charlotte, NC

Responsibilities:

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

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

Responsibilities:

• 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

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