Hands on experience with multiple versions of Oracle like 9i, 10g, 11g, and 12c and Expert level understanding of database internals. Hands on Experience in Installation, configuration, upgrading and patching of RDBMS server software and related products Strong Knowledge and Hands on Experience on backup procedures and recovery concepts. Experience in maintaining documentation and assisting client's database support within the scope of the DBA service level agreement. Experience in performing day to day monitoring and optimizing, and provides developer support for creation of databases, tables, and indexes. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. Experience in maintaining database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. And also Assisting with impact analysis of any changes made to the database objects. Hands on Experience in installation of new releases, utilities and productive tools on various clients and platforms. Administer and manage databases (Oracle and SQL Server) across all environments (production, UAT, development, disaster recovery). Support existing databases while assuring optimized performance, stability and uptime. Administration, performance monitoring, tuning, reporting, and root cause analysis. Hands on Experience in writing Oracle reports using SQL Plus or Oracle Report Writer. Adhere to software release management and version control procedures. Maintaining test database environments, data generation, test database allocations, and backup/refresh procedures. Hands on Experience in SQL Server 2008R2 and 2012 maintenance, troubleshooting and installations Experience in Managing and performing standard maintenance, monitoring, and tuning of Oracle database instances. Experience in managing all database aspects including installations, patches, performance issues tracking and assignments. Working Experience on OEM, AWR and ASH Report Generation and analysis Allocation of system storage and planning for future database storage requirements.
Database, Applications Bouncing and Security, configuration management
Hands on experience in oPatch, Adpatch, Adadmin, Adclone, RMAN backup, recovery
Good Analytical, Communication and project management skills
Workshops: Oracle Database Administration(10g), Introduction to SQL & PLSQL and Fundamentals of JAVA from NIIT.
YI09/2016 to CurrentPROFESSIONAL EXPERIANCE
TECHNICAL SKILLS Technologies Business Analytics, Data Analytics, Customer Analytics, Database Administration(DBA) Data Analytics MS Excel (Pivot Table, All type of Charts, Solver, V Lookup, Basic Macros), Power Pivot, Dax Measures.
Database Administration Oracle 9i, 10g ,11g, 12c, Weblogic, MySQL, SQL Server 2005/2008/2012, Microsoft Access 2013 Operating Systems Windows, Linux, Mac, Cent OS, Ubuntu, Fedora.
Languages SQL/T-SQL, UNIX Shell, Java, PL/SQL, JavaFX, SAS, R Language.
Technologies: Oracle 9i, 10g & 11g, SQL server 2008/2012.
Master: Information Technology and Management Management and Information SystemsPresentIllinois Institute of Technology (IIT)Chicago, USAInformation Technology and Management Management and Information Systems 4.00/4.0
Bachelor of EngineeringJune 2012Visvesvaraya Technological University (VTU)Bangalore, India3.50/4.00 Note: Available for full time work starting May 2017)