Ajay Vijayan
E-Mail: ajay13in@gmail.com
Mobile: +91-8879340880 ,+91-9773517300
Working with ZYCUS InfoTech as a Senior Oracle Database Administrator
CAREER SNAPSHOT
Database Management professional with a background that spans over 5 years
in the information technology industry in database design, performance
tuning, recovery and security.
Thorough and extensive experience as Oracle Database Administrator on
Oracle 11g and 10g environment.
Exposure of Clients engagement and Performed UAT.
CORE COMPETENCIES
Managing SAAS Infrastructure DBA Team.
Research on different products to address business need and recommending
best solutions.
Innovative approaches which would help organization to grow faster.
Recommending best suitable server / storage / network hardware to meet
business needs.
Managing the Oracle Database Licenses.
Adhering to SLAs defined for DBA Support issues & tickets.
Proficient in Installation, Configuration and Maintenance of Oracle 10g and
Oracle 11g software.
Configured Physical standby database using Data Guard for Oracle 11g
Environment.
Implemented Oracle 11G Real Application Clusters (RAC) on 2 node cluster
Production databases
Experience on applying patches using Oracle Opatch utility.
Collecting performance statistics using Statspack/AWR (Automatic Workload
Repository).
Experience in Import & Export, data pump (expdp/impdp) Utilities
Experience in taking Online, Offline and RMAN Backups
DBA support for multiple production, development, and test environments.
Implemented Database level Hardening as per client requirements.
Creating and managing database objects like tables, views, and indexes
Shell Scripting for getting data base backup automatically using cron.
Performed Switchover and Failover using sqlplus and dataguard broker.
Performed number of dev, test cloning from PROD databases.
Creating user and granting them appropriate privileges and roles.
Creating and monitoring the tablespaces, allocating tablespaces for users.
Maintaining the Alert log and troubleshooting the Errors
Provided 24x7 on-call supports. Worked beyond regular hours based on
business demands.
ACADEMICS
M.Sc. in Computer Application from Symbiosis International University (Pune).
B.Sc. in Computer Science from South Indian education society (S.I.E.S) Nerul.
TECHNICAL SKILLS
Operating Systems: Linux, Windows.
RDBMS
2008,MYSQL.
DBA Tools
: Oracle Enterprise
Developer, SQL Server Management
Studio,Cloudera.
Other Database
Languages
Oracle
: Hive,MongoDB.
: SQL.
Certifications
11g,
ITIL V3 Foundation.
Oracle Paper I - IZ0-007: SQL
Oracle
10g,
Manager,
SQL
Server
Oracle
SQL
SEED InfoTech Certified Oracle Database Administrator.
ORGANIZATIONAL EXPERIENCE
Zycus InfoTech Mumbai
Oracle DBA (July 2012 to Present)
Responsibilities.
Managing SAAS Infrastructure DBA Team.
Member of Change Advisory Board (CAB).
Maintaining 99.99% Uptime of Production and Pre-production Database.
Achieving goals set by management (MBOs).
Suggesting low cost & new technologies to top management & driving
implementation.
Identifying process flows and providing best solution to address the respective
concerns.
Research and providing Proof Of concept (POC) on different products to
address business need and recommending best solutions.
Managing infrastructure and suggesting best suitable infrastructure to clients
and for in house products.
Automate processes to reduce manual errors & increase productivity.
Planning and designing failovers to achieve 99.99% of Database availability.
Adhering to SLAs defined for DBA Support issues & tickets.
Working as oracle database administrator in maintaining Oracle 24* 7
database running in Oracle 11G.
Installing Oracle 11g R1 binaries and creating the RAC database with ASM
technologies.
Supporting the production database of min 10 TB size for various critical
application products.
Applying Oracle patches for various issues using OPatch utility.
Managing Oracle Licenses for Production Servers.
Planning and scheduling HOT Backups using RMAN.
Database schema refresh using exp/imp and impdb/expdp tools.
Monitoring Database performance using AWR, ADDM report.
Management of MYSQL Databases on linux Environment..
Angel Broking Pvt.Ltd Mumbai
Executive-Information Management
2012)
Responsibilities.
(September
2011
to
June
Monitoring Oracle database and Dataguard.
Cloning Oracle Application and Database.
Monitoring the Oracle Application (Basic).
Applying database patches and application patches.
Controlling access permissions and privileges.
Managing and testing back-up and recovery plans.
Ensuring storage, archiving, back-up and recovery procedures
Creating SR and coordinating with Oracle support for bug fix and errors
encountered.
Performing Switchover and failover on data guard.
Manually determining & resolving archive gap.
Libzz Technologies Pvt.Ltd. Mumbai
Junior Database Administrator (November 2010 to September
2011)
Responsibilities.
Installation of Oracle 10g on Windows and Linux.
Developed Shell scripts to automate database operation.
Performing Database Level Hardening.
Developing Backup Strategies for the Database.
Monitoring Database performance using AWR, ADDM report.
Granting and monitoring user access rights and privileges through Roles.
Regular checking of Alert log file.
Swastik Overseas. Chandigarh
SQL Developer (May 2008 to April 2009)
Responsibilities.
Writing SQL queries & Packages for the developers and queries for report
generation.
Fine tune the existing SQL statements for better response time
Considering both ,back-end organization of data and front-end accessibility for
end-users
Working closely with IT project managers, database programmers and web
developers
Communicating regularly with technical, applications and operational staff to
ensure database integrity and security
Daily sanity checks of the database (Support level).
Creating users, setting privileges and roles.
Developed Shell scripts to automate database operation.
AREA OF INTEREST
Oracle Forums, Reading Oracle Blogs. Big Data , Hadoop.
PERSONAL DETAILS
Date of Birth
Address
06th August, 1987
304, Siddhi Dham Apt ,Plot nos-279/280,
Sec-6, Nerul (W), Navi-Mumbai 400706,
Maharashtra.
:
Hobbies
: Football, Cricket, Music.
Languages known : Hindi, English, Malayalam, Marathi
