GURVINDER SINGH
Mob: 0091-9878-851692
E-mail: Gurvinder.gv@gmail.com
Objective:
Be
an Outrageous outstanding Oracle DBA and Database designer.
Profile:
Builds,
administers, and monitors enterprise databases, including database definition,
structure, utilization, documentation, long range requirements, operational
guidelines, protection and Focusing on the technical, organizational, and
infrastructure specifications. Provide technical guidance to power users and
developers in the use of efficient database access. Ensures database integrity,
Performance tuning, Indexing, segmentation and database recovery. Schedules,
implements, and documents database changes. Ensures a current database model
and Data dictionary are documented and available to staff. Experience included
providing support to over 30 Development, Test and Production Databases
including critical Production Databases comprising of complex and challenging Unix,
Solaris, Windows environment in Oracle versions 8i, 9i and 10g. Technical
knowledge on Installation, Upgrade, Patching, Unix, Data-guard, RMAN, Proactive
Database monitoring, Performing routine Health Checks, Automating scripts and
DBA Tasks, Capacity Planning, Database Backup and Recovery. It comprises of
Analysis, Implementation, Enhancement and Customization, Post Implementation
support and Maintenance and Documentation.
Experience
Summary:
40 months of Experience
in Softhands Software Services, from September 2008 to till date.
Designation: Oracle
DBA
Projects: Policy
Server, Charging & Rating Servers
(Prepaid & Post-paid), AAA (Authentication, Authorization and Accounting), Voucher Management, Interconnect Billing, Franchisee Management,
Customer Relationship Management, Mediation, SIP Application Server, Network Management, Smsc Information System, Comparia, Tracia, Tapas.
Client: Ericsson India Private Limited, Motorola India Private
Limited Nokia Siemens India Private Limited,
Bharat Sanchar Nigam Limited.
6 months of Experience
in BSNL,
Nodal Centre, North India from Jan 2008 to July 2008.
Designation: Project
Intern
Project: Tracia
(tracing the call
details)
Client: Bharat Sanchar Nigam
Limited, North Zone (Eight States)
Key Roles and
Responsibilities:
Technology: Utilize experience
with database theories/techniques, hardware and software technologies,
appropriate utilities, operating systems, and system architecture. Configure
and test database management software to enhance performance.
People: Act as liaison with
other departments, divisions, and organizations. Support users/ developer’s
access, upgrade planning, implementation, and resolution of database issues.
Manage and respond to information and technical guidance requests.
Customer: Work closely with
technical and client management to plan and implement database tools in support
of complex business application development requirements and processes. Utilize
standard tools to record changes and problem activities for tracking purposes.
Business: Monitor and analyze
ongoing database status, utilization, and capacity. Implement and support
database security regulations, policies, and guidelines. Develop, test and
implement complex physical database designs in support of business goals.
Financial: Research and
evaluate alternative solutions and recommend the most efficient and cost
effective database solution for multiple system designs.
Part of Four-member
DBA team managing 20 production databases and over a 10 development & test
databases with databases sizes varying from 500 GB to 50 TB.
Ø Developed UNIX shell script as part
of a LEAN Project to automate the process of Export-Import
Ø Automated space estimation based on
database growth
Ø Worked on installing Grid Control,
configuring email alerts etc
Ø Installed and upgraded databases to
11g
Ø Configured ASMs on 10g
Ø Developed UNIX Shell Scripts and
SQL Scripts to perform database checks
Ø Familiar with Internet Protocols
like SMTP, TCP/IP, XML, Proxies, etc
Ø Experienced in proactively
monitoring and maintaining databases through scripts
Ø Knowledge of database structures
and theories, Current database technologies and data analysis techniques
Ø Experience of managing multiple
RDBMS on large systems and delivering high availability services
Ø Worked on improvement and
maintenance of the databases to include rollout and upgrades
Ø Analyze data in ADDM by generating
AWR reports
Ø Good knowledge of Dataguard. Worked on configuring Logical and Physical
Standby Databases
Ø Performing a regular Database
Administration activity which involves: Database Upgrade from 8i to 10g,
Installation of Oracle Software, Cloning Databases, Database Reorg and Backup
and Recovery
Ø Fine tuned Memory, I/O and Database
Objects
Ø Provided technical leadership in
all areas of technical writing. Have configured Unix scripts to proactively
handle Database alerts in areas of Tablespace usage, mount point usage,
Database level auditing etc
Ø Worked extensively on providing
detailed Database analysis in terms of sizing (Capacity Planning)
Ø Implemented Disaster-Recovery
techniques
Ø Performed SQL tuning by using
Explain Plan and Tkprof
Ø Mentored in-house DBAs to assume
higher levels of responsibility
Ø Analyzed Database Performance based
on Statspack and AWR report results
Ø Applied quarterly CPU Patches
Ø Solve out of band request.
Ø Resolved listener and tnsnames.ora
issues
Ø Performed Remote DBA tasks for
Different Nodal Centers across India
Ø Design, Install, Tune and Monitor
Oracle databases
Ø Extensively used Hp data protector
Ø Monitor and optimize the
Performance of the database
Ø Establishment of security policies
for access to the system and ensuring round the clock database availability
Ø Establishment of sound backup and
recovery policies and procedures. Taking split mirror backup, hot backup, cold
backup, file system backup and their restoration, recovery
Ø Creation of Operating System Users,
Volume Groups, Logical Volume
Ø User and Password management for OS
and database users
Ø Business Copy/Split Mirror Backup:
Take daily BC backup of the databases and Tape backup
Ø Taking OS backup (Ignite Backup) on
monthly basis
Ø File System Management: Monitoring
file systems for space availability (Includes clearing of logs, core dumps and
archive management)
Ø Tape Library Maintenance’s level
maintenance of ESL9595 Tape library drives and media for smooth and consistent
backup operation
Ø
Knowledge
of Information Technology
Infrastructure Library
Ø Knowledge of RAC
Hp-UX Skills
Ø HP
Logical Volume Manager (LVM),
Ø Troubleshooting Hp-unix through SAM.
Ø User
account management -- creation, deletion, and shifting.
Ø Device
management and configuration on HPUX systems.
Ø Swap
Space Management and Kernel configuration
Ø Disk
Mirroring and Management using MirrorDisk/UX
Ø Network
configuration of NFS, DNS.
Ø Automating
Jobs using Cron & AT
Ø File
systems backup and restore Using fbackup, tar
Ø Installation
of Supported packages and updation of patches
Ø Monitoring
Tools
Technical
Summary:
Languages ----- SQL, PL/SQL, C++,
Backup & Recovery ----- RMAN,
Data Protector
Databases ----- Oracle 11g/10g/9i/8i
Operating System ----- Hp-Unix, Solaris, Windows (Server Family)
Other Tools ----- Erwin, Toad, SQL Analyzer, Exceed, Xmanager, Oracle
Designer
Academic Qualification:
Ø Bachelor of Technology (I.T) ,Punjab
Technical University,2008,Aggregate Percentage: 72.4%
Ø Oracle Certified Professional 10g
Workshop/Training
Programs:
Ø Oracle Certified Professional
training by Oracle Training Academy
Ø Training in Cellular Mobile telecom
Services, Nodal Center, North India in
Oracle Administration
Ø HP-UX Fundamentals
from Hp Education India
Ø Advance Networking from
Hp Education India
Ø HCL Solaris I II System Administration from
HCL Education
Awards and
Achievements:
Ø
Innovated
automated space estimation based on Database growth which served as proactive
measure personally appreciated by client.
Ø
Worked
to recover 10 production databases over 3 continuous days during a Disaster
Recovery.
Strengths:
Ø
Ability to work collaboratively and commitment to
achieve corporate goals.
Ø
A vision of the outcomes, and a style that conveys
that vision so others can grasp it
Ø
Strong communication abilities to create understanding
and clarity
Ø
Emotional intelligence to read situations, and
strength to take a stand as needed
Ø
Ability to connect and work with a range of people,
professions and styles
Ø
A sense of deadlines and project timelines
Ø
An ability to gain buy-in from others
Ø
Good negotiating skills, for overall work agreements,
and for day-to-day issues
Ø
Planning skills and the ability to articulate the plan
and steps to others
Ø
Dealing with change, and flexibility to adapt and help
others to adapt
Ø
Credibility of track record, reputation, presentation
and explanatory power,
Ø
Skills in decision-making, problem-solving and
negotiating
Personal Info:
Ø
DOB : Jan-16-1986
Ø
Nationality | Sex: Indian
| Male
Ø
Marital Status: Unmarried
Ø
Reference: On
request
Ø
Address: #3424, Sector 23,Gurgoan,Haryana, INDIA 122001
Declaration:
I hereby
declare that the information furnished above is true to the best of my
knowledge and belief.
Gurvinder
Singh
