Orcale and MS SQL database administrator

SWETOSREE SINHA

Email: **********@*****.***

Phone: +1-217-***-****

SUMMARY

• 5 years of IT experience as “Oracle and MS SQL DBA” closely working with Business stakeholders and provide consultative and technical support services for all major database development and system integration tasks.

• Analyzing customer's technical requirements, development, management, maintenance and production support projects of Oracle Database on platforms like UNIX/LINUX/AIX/SUN Solaris.

• Worked onshore with Client Liberty Global in Europe (Amsterdam).

• Participate actively in planning strategies for upcoming databases required for business needs in perspective of capacity planning, performance and available technology.

• Strong technical and interpersonal skills combined with great commitment towards meeting deadlines.

• Experience working in both team and individual environments. Always eager to learn new technologies and implement them in challenging environment.

ORACLE DBA SKILLS

Skills Particulars

Oracle Certified Associate 12c:SQL Fundamentals (1Z0–061) Installation, Configuration & upgradation Oracle 12c, 11gR2, 10g Performance Tuning Proactive & Reactive

Monitoring Log Files Alert, Redo, Listener, Trace

DB Backup Export/Import, data Pump

RMAN Script, backup, recovery

Data Guard Creation, Configuration, synch

Patching CPU, PSU, Bug fix, Security

Cloning From Prod to Non-Prod environment

ASM Configuration & Utilization

RAC Activity, start-stop, health check

Golden Gate Installation, Configuration

OEM Monitoring, performance, activity

Report Analysis AWR & ASH

DB Health Check Archive, tablespace, backup, synch, alert MS SQL DBA SKILLS

Skills Particulars

MS SQL Server 2012 Installation

Table, Index Column Store Index

Backup & Restore Full, Differential & Log Transactional Recovery Model Full, Simple & Bulk Logged

SQL Server & Agent Maintenance Jobs Created & Configured DB Mirroring Setup Configuration

Always On Setup Configuration

TECHNICAL SKILLS

Oracle Database Tools SQL Loader, SQL Plus Prompt, OEM, SQL Developer, Grid Control Operating Systems LINUX, SOLARIS, AIX

RDBMS Oracle 10gR2, 11gR2, 12c

Tools & Utilities Export/Import, RMAN, Data Pump, Data Guard, RAC Languages C, UNIX shell scripts, SQL, Python

Ticketing Tools ITSM, ICCM & Axios

Microsoft SQL server

Management Studio

Most of the MS SQL tasks are performed through it

Microsoft SQL server

configuration manager

Installed & configured

PROFESSIONAL EXPERIENCE

Employer: Accenture

Client: Global Payments Dec 2014 – May 2017

Location: Atlanta, GA

Global Payments Inc has been a market leader in the U.S. since the 1960s when its former parent company, National Data Corporation, pioneered a specialized data processing system. Global Payments specialize in card payment processing for customers ranging in size from owner-managed businesses to multinationals in every sector. Headquartered in Atlanta, Georgia.

RESPONSIBILITIES

• Synchronized distributed databases for development and system test. Maintained Database security.

• Created new roles and users. Monitored and optimized production database performance.

• Resolution of day to day related issues, documentation of Oracle DBA routine tasks.

• Participated in On-Call rotation & providing 24x7 support for the databases. Resolved assigned emergency tickets.

• Generated AWR, ASH reports from Oracle 11g/12c database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.

• Recovering Databases when there is any Physical or Logical Corruption.

• Set up auditing in production databases to be compliant with SOX requirements.

• Backed up databases utilizing RMAN. Worked with Operations to resolve problems with the media servers.

• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server.

• Created physical standby databases.

• Shell Scripting for monitoring System Synchronization, Database growth size, monitoring free space availability at Database level and at Disk Level, Backups, and Performance and Log rotations.

• Provided support for ASM as database storage.

• Sizing the SGA, sizing the db. Buffers, shared SQL area, log buffer based on the requirements.

• Job scheduling using cron, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.

• Daily monitoring like alerts checking, log checking, fixing space issues, fixing application connectivity issues, tuning databases.

• Build and maintain Disaster Recovery solutions (Data Guard and 2 standby databases), confirmed with periodic DR Switchover and Failover.

• Extensive experience in Patching, applying patches for 11g & 12c.

• Performed Tuning (both proactive & reactive)

• Used ticketing tools – ICCM & Axios

• Experience on installation and configuration of GoldenGate software 12c.

• Installed MS SQL Server 2012, provided required roles and privileges to users.

• Worked on table & index creation. Specifically, “Column Store Index”

• Recovery Model (Full, Simple & Bulk Logged)

• Experience in DB mirroring, Log Shipping

• Setup & Configure “Always ON”

Employer: Accenture

Client: Liberty Global Sept 2012 – Nov 2014

Location: London

Liberty Global plc is an American international telecommunications and television company. It was formed in 2005 by the merger of the international arm of Liberty Media and UGC (UnitedGlobalCom). Liberty Global is the largest broadband internet service provider outside the US. Headquartered in London, United Kingdom RESPONSIBILITIES

• Worked as part of Environment Management Team.

• Performed Environment build and refresh for different Releases & Database cloning.

• Performing patch reviews, patch installations and patch deliveries.

• Providing support for releases at all stages until Go Lives, Planning and scheduling backup jobs using crontab.

• Implemented and supported oracle database and application environment management activities.

• Implemented Environment build/refresh through Nolio Automation Tool.

• Worked on Puttty & Citrix using FTP, SFTP & SCP Protocol for different Application Server (DEV, MT, JIT, UAT, ORT, Prod).

• Ensure optimal performance by using AWR.

• Responsible for the administration of many databases of Oracle 10g/11gR2

• Closely monitor the CPU, memory usage, I/O contention on servers using top

• Perform Data Refresh/Cloning from Production environment to setup QA/ DEV

• Worked on SQL plus prompt & SQL Developer along with DB servers

• Used ticketing Tool – ITSM.

ACADEMICS

University/School Degree Percentage Year

West Bengal University of Technology Bachelor of Technology 85.5% 7/2012 Belrui N.G. Institution Higher Secondary Education 82% 5/2008 J K D U B School Secondary Education 89.6% 6/2006

ACHIEVEMENT

• Got “Rising Star” Award from Accenture on 2013 (September).

• Got certificate from IIT Bombay for Robotics on 2010.

Contact this candidate