Balwan Singh Email & Phone Number

Noida, Uttar Pradesh, India

New Delhi Area, India

Hi Friends,Today on 01 May 2020, is my last working day in Snapdeal.It has been 32nd year of my working life out of which 15.5 years were spent with Indian Air Force and remaining with corporate world in multiple organisations. I consider myself very fortunate and privileged enough for getting the opportunity to work with many wonderful people along my journey.I am grateful to Almighty God for providing me such wonderful opportunities in my life. At the present moment of my life I considered it proper to take a break to do self introspection before deciding next course of action. I shall provide the update in future.I wish all of you a very successful career ahead and thank you for everything.I wish every corporate entity wherever I have worked or not worked, good progress and prosperity so that they continue to positively impact society and nation's growth.Best Regards,Balwan Singh+91-8130918800

Bengaluru Area, India

 Install RAC, configure Data Guard/Streams/RMAN/DR/Grid Control/ASM Managing oracle databases and ensuring their performance, availability and security Database Administration across Americas, EMEA and AP regions as Geo SME Lead  Database Backup/Recovery Policy and DR – Resulting business continuity Database Security Management- Resulting a Business continuity Database License Management and SLA Adherence  Database Capacity Planning – Result in business continuity Change management for all DB related changes – Result in business continuity Database Risk Assessment and closure of Audit findings Innovation in IT -Service result in business benefit Performance Tuning Design and implementation of Backup/Recovery/Disaster Recovery strategies  Installation, Configuration and Management of Backup through TSM Netbackup Sizing & Fine tuning of the Database: Memory (SGA), I/O, and Application Tuning Improvement and maintenance of the databases to include rollout and upgrades Database re-organizations to assist performance and ensure maximum uptime  Database Patch management and Server Consolidation

Gurgaon, India

 Managing the Oracle database (more than 300+ instances) with RAC, Data Guard, Streams, CDC and Grid Control configured across the enterprise  Working with both technical and application teams for database administration activities and with other vendors for supporting L1/L2/L3 escalated requests Planning of Database Install/Setup/Backup/Recovery/DR Implementation by coordinating with other vendors, application & project teams Upgrade oracle database version and apply security patches as and when required Carry out supervisory responsibilities include planning, assigning and directing work Ensure to deliver committed services to internal & external customers Adherence to operation and service management processes and ensure that systems, organization processes & unit practices adhere to company security and quality compliance Conduct periodic reviews with team MIS reporting to customer (on Service performance) and Management Recruitment and team building Timely communication to Customer/Management/Team on Incidents and Escalations Manage customer’s/team’s escalations and ensure the closure of issue with RCA

Gurgaon, India

 Maintaining 24x7 availability for business critical production servers (4 node RAC Clusters) DBA support to the application team for loading and testing databases in 9i/10g  Partitioning of tables and indexes and database migration  Shell scripting for various DBA related tasks DBA checks on the production DBs through scripts at regular intervals Performance Tuning (database, h/w, network, SQL, application)and capacity planning Managing the oracle installation, configuration, up gradations & maintenance Scheduling backups and restoring for DB cloning activity Maintaining database availability for business critical components Planned DR activities and high availability solutions Managerial Responsibilities Coordinating across the project team and client; conducting periodic project progress review meetings Leading Infrastructure project of Indiabulls Securities Ltd Co-ordination with vendors (Oracle, DELL) for support  Co-ordination with VSNL data centers (Mumbai) during maintenance and DR activity

New Delhi Area, India

 Installing, configuring and upgrading Oracle Database on Solaris/Linux Platform  Configuring database in Shared Server or Dedicated Server Mode Managing listeners and services using Oracle Net CA or Oracle Net Manager DBA support to the application team for loading and testing databases in 9i  Shell scripting for various DBA related tasks Performance tuning & capacity paining Evaluating Oracle features & related products setup DBA checks on the production DBs through scripts at defined intervals  Monitoring database using Oracle Enterprise Manager Maintaining logical/physical standby databases Maintaining replication through materialized views

New Delhi Area, India

 Oracle database software installation  Database creation and configuration  Schema creation and analyze Backup, recovery and performance tuning Shell scripting and Export/Import and data loading

India

Oracle Database Admin (Jan 2000 – Aug 04)Database install and configure on Windows and SCO Unix PlatformsExport/Import, data loading and RMAN backupsAutomation of jobs through scripts and scheduler Analyzing stats and tuning SQLsInvolved in recovery scenariosResizing of tablespaces and capacity planningMonitoring database performance=================================== IT Experience (Sep 97- Dec 99)Windows installations and configurationLAN/WAN setupEncrypted data transfers between Air Force command cellsOn job training coordinatorEDP office administration tasksNetwork monitoringWindows administration & troubleshooting=====================================================Non-IT Experience (Feb 89 - Aug 97) - As Air Defence Systems Operator