PROFESSIONAL SUMMARY:

• Results - oriented IT professional who has more than fourteen years of Oracle, MSSQL Server, MySQL database administration experience along with Hadoop implementation and support
• Strong analytical, interpersonal, communication, troubleshooting and problem solving abilities
• Experience in Oracle, SQL Server and MySQL Database design, modeling, performance tuning, transactional processing, pl/sql & T-sql programming, database migration, and Shell Scripting.
• Possess number of different professional certifications and training including OCP, MCP, SCSA
• Good understanding and experience working in a highly professional environment
• Excellent understanding and in-depth knowledge of Oracle databases, RAC, ASM, OEM, Data Guard, MSSQL Server, Hadoop architecture including underlying frameworks and Ecosystem
• Worked extensively on database installation, configuration, patching, upgrades, replication, cloning, backup, recovery, performance, tuning and security for both clustered and non-clustered databases
• Excellent hands-on database administration experience on Clustered Servers, Dedicated Servers, Data Guard Servers, Distributed Servers, Parallel Servers and VLDB
• Extensive experience of database upgrades and migration from oracle 8i to oracle 9i, oracle 9i to oracle 10g, oracle 10g to oracle 11g and from MSSQL Server to Oracle
• Extensively worked on database backups and recoveries using RMAN, Imp/Exp, Data Pump, PL/SQL, Shell scripting and Confidential Tivoli Storage Manager
• Good experience writing PL/SQL and Shell scripts to automate different DBA related activities
• Extensive experience using OEM (10g Grid Control, 12c Cloud Control), Toad and SQL Navigator
• Experience in database administration of MSSQL and MySQL servers including user administration, backup, recovery, performance monitoring and tuning
• MSSQL Server In-Place and Side by Side migrations, version/edition upgrades, planning and implementation
• SQL Server patching and hot fix implementation in production environment
• Experience in database design, Performance Analysis, SQL query tuning, explain Plan and tkprof. Extensive experience in using key Oracle performance-related features such as execution plans, hints, indexes, partitioning, temporary tables.
• Excellent knowledge of Hadoop Architecture and ecosystems such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, Map Reduce, YARN programming paradigm
• Expertise in installing, configuring and using Hadoop ecosystem which include Hadoop Map Reduce, HDFS, HBase, Oozie, Hive, Zookeeper, Sqoop, Pig, Flume
• Experience in importing and exporting data between HDFS and Relational Database Management systems using Sqoop
• Experience with distributed computation tools such as Apache Spark, Ambari,
• Experience in managing and reviewing Hadoop log files
• Experience working with Oracle Support and using My Oracle Support to create and manage Service Requests, to download patches and to read technical note
• 24/7 SLA based core production support and critical operation monitoring following the Agile Scrum methodology

TECHNICAL SKILLS:

Operating Systems: UNIX (AIX, HP, Sun Solaris, Linux), Windows 9.x, NT, XP, 2000, 2003Vista, 2007, 2010

Languages: SQL, PL/SQL, Transact SQL, C++, C#, Shell scripting, JAVA, HTMLVisual Basic

Databases (RDBMS and NOSQL): Oracle (8i, 9i, 10g, 11g, 12c), Oracle Lite, MSSQL Server (2000, 2005, 2008, 2012), HBase, MongoDB, MySQL, MariaDB

Application Servers: Oracle Application Server(9i, 10g), Oracle Collaboration Suite(9i, 10g)Oracle E-Business Suite Release 11,12

Hadoop Ecosystem and administration tools: Hive, Pig, Sqoop, Flume, Zookeeper, Mahout, Oozie, YARN, HDFS, HBase, Ambari, Spark

Management, Administration, Monitoring and Performance Tuning Tools: OEM(Grid Control, Cloud Control), Oracle Net ManagerSQL Plus, iSQL Plus,, Data Guard, RMAN, Import/Export, SQL*LoaderData Pump, Oracle Discoverer, Space Manager, Schema Manager, TOADSQL Navigator, Tivoli Storage Manager(TSM), BMC Patrol, RemedyMaestro, MS Enterprise Manager, SQL Server Management StudioSQL Query Analyzer, Pentaho, Puppet

Network Software: VPN, RAS, FTP, Telnet, Terminal Server, SSH, Exceed, Exceed FTPSCP3, VNC, Putty, Remote Desktop, Citrix

Methodologies: Client Server, Multi Tier Architecture, WAN, LAN. SAN, VMwareCitrix, OPS, ASM, RAC

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

Senior Database Consultant (DBA)

Environment: Oracle 11g, 12c on Linux RHEL 6, 7, ASM, RAC, RMAN, Data Guard, Partitioning, OEM 12c, MySQL, MariaDB

Responsibilities:

• 24/7 operational support for multiple production oracle RAC and MySQL database servers
• Production, development and QA database administration, troubleshooting and maintenance
• Oracle, MySQL database server software installation, configuration, upgrade and patching
• Oracle Enterprise Manager 12c Cloud Control installation, configuration, upgrade and patching
• Database performance monitoring, tuning, backup and recovery
• Apply available PSU, CPU or bug fix patches as required or suggested by oracle support
• Monitor database activities which includes but not limited to database status, long-running transactions, deadlock detection, database daily space growth, database files IO
• Take full, incremental database backups and perform complete, incomplete or partial recoveries
• Write multiple SQL, RMAN and shell scripts to automate database backups and cloning
• Configure database flashback in development and testing and restore database as needed
• Write different scripts to schedule different routine or ad-hoc jobs using OEM or crontab
• Create and manage tablespaces, set their growth and manage their sizes and space
• Regularly monitor Alert log, trace files to check errors and warnings and manage their growth
• Manage archive log, schedule their backups and implement retention policy for auto deletion
• Startup checks and proactive monitoring to ensure operational stability of databases
• Migrate and upgrade Oracle and MySQL databases from one version to another
• Create and maintain scheduled jobs, maintenance plans and native backups
• Perform database shrinking operations, rebuild indexes or move files while having space issues
• Configured Confidential in oracle to use captured data in different other databases
• Run different diagnostic tests, extract AWR reports to diagnose performance related issues
• Work with development team to help and identify potential problems at first stage
• Assist teams of developers, database engineers and QA engineers to promote new code, run scripts, run different tests and help performing other database related tasks
• Develop and tune Oracle code to achieve system performance requirements by reviewing stats-pack, SQL Trace, Tkprof, explain plan results. Identify and communicate system deficiencies.
• Random drills for health check of production database and updating to avoid potential problems
• Making sure that the platform is able to scale to meet any future requirements
• Work on others projects and give expert analysis on potential bottlenecks in production and development databases

Confidential, New York, NY

Senior Database Administrator / Hadoop Administrator

Environment: Oracle 10g, 11g RAC on Linux RHEL 5.5, HP -UX (ia64), OEM 10g, RMAN, Data Guard and Partitioning, MSSQL Server 2008 on Windows 2003, 7, Hadoop, HBase, Hive, Pig, Sqoop

Responsibilities:

• Administration and trouble shooting of Oracle, SQL Server databases and Hadoop framework
• Install and configure database servers and Hadoop framework along with Hadoop ecosystem
• Database performance monitoring, performance and tuning, backup and recovery
• Database configuration, maintenance, upgrade, migration, replication and patching
• Check and apply available upgrades and CPU vulnerable security patches as per requirement
• Monitoring database activities which includes but not limited to database status, long-running transactions, deadlock detection, database daily space growth, database files IO
• Perform full and incremental database backups and complete, incomplete and partial recoveries
• Write SQL and shell scripts to run or schedule different routine or ad-hoc jobs using crontab
• Analyze data integrity and database physical/logical structure
• Implement database security by using different authentication methods and security procedures
• Create and manage tablespaces, set their growth and manage their sizes and space
• Regularly monitor Alert log and trace files for warnings and errors and managing their growth
• Manage archive log, schedule their backups and implement retention policy for auto deletion
• Startup checks and proactive monitoring to ensure operational stability of databases
• Create and manage database users, assigning quota on tablespace and granting roles/privileges
• Install, configure and support production SQL Server 2000/2005/2008 databases
• Applying latest service packs and hot fixes to all SQL servers
• Keep tracking of database sizes and logfile growth of SQL servers and manage them
• Monitoring the status of SQL Server by going through the error logs, NT event logs
• Migrate and upgrade Oracle and MSSQL Server databases from one version to another
• Data migration from existing SQL databases to fully-distributed Hadoop NoSQL HBase database
• Creating and Maintaining scheduled jobs, Maintenance plans and native backups
• Perform shrink operations, rebuild indexes or move files while having space issues
• Troubleshooting performance issues, backup and recovery issues and database issues
• Serve developers ad-hoc requests for script promotions and other database related issues
• Provide support to application teams for application related database needs
• Identifications of performance bottlenecks in production databases
• Work with development team to help and identify potential problems at first stage
• Random drills for health check of production database and updating to avoid potential problems
• Making sure that the platform is able to scale to meet any future requirements
• Work on others projects and give expert analysis on potential bottlenecks in production and development databases
• Implementation and administration of Hadoop framework and Hadoop ecosystem
• Work with infrastructure team to propose and deploy new hardware and software environment or to expand existing environment required for Hadoop
• Installation and configuration of Linux operating system to build multi node cluster environment
• Install and configure Hadoop Framework along with HDFS, HBase, Hive, Pig and Sqoop
• Maintenance of Hadoop Cluster, commissioning of new nodes and decommissioning of existing nodes manually or by using different administration and management tools
• Review and manage Hadoop log files for performance and errors
• File system as well as disk space monitoring and management
• Support and maintenance of Hadoop Distributed File System(HDFS)
• Upgrade operating system and Hadoop software by installing Linux rpms and applying patches

Confidential, Chatham, ON

Senior Database Administrator

Environment: Oracle (8i, 9i, 10g, 11g), Partitioning, Grid Control, OEM 10g, Oracle Spatial, Oracle Lite, RAC, ASM, RMAN, Data Guard, TOAD, SQL Navigator, Tivoli Storage Manager MSSQL Server (2000, 2005, 2008), AIX (5L, 6L), SAN, Windows (2003, 7), 350 databases

Responsibilities:

• Primary Database administrator for several production databases
• As a production support DBA, monitored the database queue in the problem and change management system (Remedy) for approximately 350 databases to resolve the problem
• Performed installation, configuration, migration, upgrade and patching of Oracle 8i, 9i, 10g, 11g databases on Linux/AIX/Windows in both RAC and non-RAC environment
• Installed, configured and supported Oracle Spatial and Oracle Lite required by different applications to work with Oracle 9i,10g and 11g databases
• Developed database backup and recovery strategies for more than 200 databases
• Configured RMAN to work with Confidential Tivoli Storage Manager to take oracle database backups, perform database replication and all types of database recoveries
• Participated in High-Availability designing using RAC, Data Guard, Flashback, and log shipping
• Performed database replication, database refresh, data migration from SQL to Oracle, from OLTP to OLAP using Imp/Exp, DataPump or SQL*Loader
• Analyzed data integrity and database physical and logical structure
• Installed, configured, supported and upgraded MSSQL production and development databases
• Performed MSSQL database backups, complete, incomplete and partial recoveries
• Monitored database performance using ASH, AWR data, V$ views, Oracle EM, Hotsos, Toad and SQL Navigator to perform tuning and suggest different way outs to fix issues
• Checked and applied available upgrades, PSU and CPU vulnerable security patches
• Upgraded Oracle and SQL Server databases to newer versions and migrated databases from SQL Server to Oracle and from windows to Linux/AIX
• Implemented different security procedures at OS and database level to secure the databases and to fulfill the SOX(Sarbanes-Oxley) requirement for auditing
• Performed database testing to check all the databases are Sarbanes-Oxley (SOX) compliance
• Provided support to application teams for application related database needs
• Provided 24x7 on-call support for all Oracle and SQL production databases on weekly standby
• Led several different projects to install software, implement changes and roll out different upgrade or security patches across all the oracle or SQL Server databases

Confidential, Mississauga, ON

Application Database Administrator

Environment: Oracle 9i, 10g, Oracle AS 9i, 10g, Oracle Collaboration Suite, Linux (Red Hat Enterprise AS 4.0)

Responsibilities:

• Installed and configured Oracle 9i, 10g and Oracle 10g Application Server(Infrastructure and Midtier) on Linux (Red Hat Enterprise AS 4)
• Installed and configured Oracle Collaboration suite for all incoming and outgoing emails
• Enrolled users and maintained system security by controlling and monitoring users
• Performed database backups and restores as needed using RMAN and database control
• Loaded data into oracle databases from different resources including text files using SQL Loader
• Migrated data from existing databases to new Oracle10g Databases using exp/imp or data pump
• Installed and upgraded application/database software with service packs, packages and patches
• Tuning of SGA to avoid fragmentation of Shared Pool and memory structures
• Wrote different SQL and XML scripts to configure users email accounts and build security
• Configured database monitoring and auditing at session and database level

Confidential, Mississauga, ON

Database Administrator

Environment: Windows 2000 Server, Linux, Oracle 8, 8i, 9i, SQL Server 2000, XP Siebel 7

Responsibilities:

• Installed, configured and supported oracle and MSSQL Server on Linux and Windows Servers
• Upgraded Oracle version 8.1.7 to oracle version 9.2.0 using direct path and Imp/Exp utility
• Installed and configured Oracle Parallel Servers(OPS) and Oracle Replication Servers(ORS)
• Created and managed user accounts, permissions, roles and profiles to maintain security
• Checked and maintained system and database performance using different tools and techniques
• Took routine backups, performed database recovery(complete/incomplete) with or without tools
• Developed Unix/Linux and SQL scripts to schedule, monitor and control batch jobs
• Provided technical support for Oracle on Win2000/XP, Linux and related applications
• Participated in resolving issues, maintaining network stability and users training
• Performed new installations of Client-Server Linux-based control systems with Oracle databases
• Performed system troubleshooting, upgrading and cross-platform (Windows-Linux) migration
• Implemented and supported advanced control applications and provide system integration and post-implementation services

Confidential

System / Database Administrator

Environment: SQL Server 2000, Windows NT/2000/XP, Linux, Lotus Notes, Siebel 5, 6

Responsibilities:

• Helped customers regarding their IT related needs and provide best solutions for their software, hardware or networking requirements
• Fixed issues by using technical knowledge, troubleshooting and problem solving skills
• Provided technical knowledge and training after the solution implementation or issue resolution
• Installed, configured and supported different applications, system and database software which includes Windows, Linux, Lotus Notes, SQL Server, Ms Office and more
• Applied service packs and patches to all installed operating system, applications and software
• Created and maintained user logins, user profiles, system policies and security
• Found solutions for new or unknown issues and added those solutions into solutions database
• Log and documented all the requests in ticketing database system by using Siebel (CRM)
• Acted as a mentor for newly hired or junior associates when necessary
• Helped others at the department level in maintaining and improving service level