Database Administrator
Resume:
Akshay Vinod Punnath
Chirag, Valapil Padam,
Perumanna P.O., Kozikode,
Kerala - 673026
PH NO: 888-***-****
******************@*****.***
Professional Profile Jun 2011-present
● Working as SQL Corporate Trainer at Koenig Solutions.
● Worked as Senior Associate at Infosys Limited from Jun 2011 - Oct 2014.
● Over 3 years of IT experience as an analyst and consultant for development and maintenance of IMS
(Infrastructure Management Services) projects inside Infosys Limited.
● Setup various RAC builds and SQL Server installations.
● Profile also includes handling corporate training, on various technologies for both new comers and
experienced folks working on projects at various locations.
● Clients include Barclays, BMW, Sunguard, Astrazeneca, Pfiser.
Certifications
● IZ0-052 certified
● 70-432 Microsoft SQL Server 2008, Implementation and Maintenance
● 70-461 Querying Microsoft SQL Server 2012 (MCP ID: 11579240
● 70-462 Administering Microsoft SQL Server 2012 Databases (MCP ID: 11579240)
● 70-464 Developing Microsoft SQL Server Databases (MS ID: MS0609976917)
● 70-465 Designing Database Solutions for Microsoft SQL Server (MS ID: MS0609976917)
Skills:
● Oracle Database Implementation and Configuration
o Installation of 10g, 11g and 12c.
o Database deployment, User, security and Storage management
o Backup and Recovery and Flashback Technology
o User Managed
o RMAN
o Migration and duplication of database.
o Data Movement
o Exp/Imp
o Data Pump
o Transportable Tablespaces
● Performance Tuning in Oracle Database environment
o AWR snapshots, Baselines creation and AWR report generation, and creation of ADDM report.
o Resource Manager
o Tuning using OWI
o Capture load and Replay the load using Database Replay
o SQL tuning using explain plan, SQL tracing, autotrace.
o SQL performance Analyzer
o SQL tuning Advisor
o Memory tuning
o I/O tuning
o
● Real Application Cluster Deployment and Management
o Installation in grid infrastructure 11g (raw devices, ASM, NFS)
o Removing and Reconfiguring grid infrastructure configuration
o Voting disk and OCR configuration
o Clusterware administration and utilities (CRSCTL)
o Clustered Database Management and Deployment
o Migration of database from RAC to stand alone, RAC to single instance, single instance to
RAC.
o Backup and Recovery in RAC environment.
● Automatic Storage Management
o ASM installation in standalone and grid infrastructure.
o ASM instance configuration and Management
o Diskgroup configuration.
o ASM Files (Redundancy, Mirroring, Striping and Access Controls)
o ADVM, ACFS
● Data Guard Configuration and Deployment
o Physical, logical and snapshot standby configuration.
o Data Guard Services and Protection Modes
o Data Guard Broker configuration
o Disaster Recovery design for RAC through Data Guard.
● SQL Server Management and Configuration
o Installation of SQL Server 2008, 2008R2 and 2012.
o Database creation and management, Filegroup and filestream management
o SQL Server security and auditing
o Backup and recovery, database snapshot.
o Export/import.
o SQL Server Agent (Jobs, Schedules, Alerts, Operators, Proxy)
o Policy based management
o Maintenance plans
● SQL Server Performance tuning using various utilities
o SQL Server Profiler
o DBCC
o Resource Governor
o Database Tuning Advisor
● High Availability in SQL Server
o Database mirroring configuration and Management
o Asynchronous and synchronous Mirroring
o Manual and Automatic failover
o Adding Witness server
o Enabling Reporting on secondary server
o Log shipping
o Replication
o Snapshot Replication
o Merge Replication
o Transactional Replication
o Peer-to-peer Replication
o SQL Server clustering and SQL Server Availability groups in 2012
● Basic Administration DB2 in Linux
o Installation of DB2 v9.7
o Database creation and management
o Storage and Tablespace management
o DB2 security
o DB2 utilities
o Export/import and load
o Backup and recovery
o Performance tuning
Operating Systems
● REHL 6
o Managing KVM VMs
o Virtual Networking and storage configuration
o Basic RHEL administration
● Windows Server 2008 R2, 2012
o Managing HyperV VMs
o Virtual Networking and storage configuration
o Managing Virtual Machines in VMWare Workstation.
o Active directory and Basic server administration
o Powershell Administration
Education
2007-2011 B.Tech Bio-Informatics from National Institute of CGPA-7.63/10
Technology, Bhopal
2007 XII KendriyaVidyalaya No.1, West Hill, Percentage: 81.6
Kozhikode, Kerala
2005 X KendriyaVidyalaya No.1, West Hill, Percentage: 81.6
Kozhikode, Kerala
Personal and Contact info
Name: Akshay Vinod Punnath
Gender: Male
Date of Birth: 09.03.1990
Nationality: Indian
Languages: English, Hindi, Malayalam
Contact this candidate