Resume

Sign in

Customer Service Sql/oracle Server

Location:
Irving, Texas, United States
Posted:
October 06, 2016

Contact this candidate

Devika Madhukar

acwx54@r.postjobfree.com Phone: (972) ***-**** Mobile: (214) ***-****

SUMMARY

•Over 2 years of experience as SQL Server and Oracle Database Administrator

•7 years of experience in marketing / customer service & accounting positions

EXPERIENCE

Cyber Skills, Inc (Dallas, TX) 2013 – present

Database Administrator

Production Support includes supporting SQL Server and Oracle databases

Oracle

oInstalling 11gR2 Oracle RDBMS software, creating standalone 11.2.0.4 databases, user tablespaces

oPlanning and upgrading databases as needed

oConfiguring databases for archive (transaction) logging

oConfiguring Listener for application/user connectivity

oCreating users and granting privileges

oManaging tablespaces – added datafiles, resized datafiles

oDatabase Tuning

Separated tablespaces for tables and indexes across separate disk farms to improve read/write performance

Gathering segment statistics and verifying explain plans for poorly performing SQL (using Cloud Control or SQL commands)

Identifying performance bottlenecks using AWR reports

oBacked up databases using “EXP” and “RMAN” utilities

oAssisted DBAs in setting up Physical Standby Databases using Data Guard. Familiar with verifying data guard status using Cloud Control (Grid Control). Also, familiar with high level architectural concepts of Real Application Cluster (RAC) typically deployed for high-availability.

SQL Server

oInstalling SQL Server 2012 software and created databases

oConfiguring and validating database and transaction log backups

oSetting up database user access and granting appropriate roles and privileges

oUsing Spotlight for SQL Server to monitor overall health/performance of the database

oUsing SQL Management Studio to administer databases

oPartnered with senior DBA to assess performance of databases on a shared server and recommended use of flash drive to alleviate locking bottlenecks due to concurrency

oFamiliar with database restore and concepts of database replication

Application Support includes:

Contributing to Projects and working together with application team by installing software, creating Databases, configuring listeners, and identifying non-optimized SQL

Implementing password policy standards and delivering new user account requests based on new project SOWs

PwrSolutions, Inc. (Dallas, TX) 2009 - 2013

Accounts Associate

•Supported the Financial Controller with monthly accounting tasks, by generating Reports & Invoices for contracts, using intermediate to advanced level methods in Excel, Nova Timesheets and other internal customized tools

•Responsible for follow up’s on all aspects of day to day accounts, invoicing processes and contract agreements

SKILLS

•Database: Oracle 11g, SQL Server 2012 (familiar)

•Operating Systems: Linux, Windows

•Tools: Oracle Enterprise Manager (OEM), Toad, SQL Developer

•Languages: PL/SQL

STRENGTHS

•Ability to work independently with effective and on-time delivery of tasks in a versatile and flexible environment

•Have strong commitment to excellence and high standards. A quick learner with deep attention to detail and willingness to learn new technologies.

•Sound communications skills - both verbal and written

EDUCATION AND TRAINING

•Bachelor’s Degree in Commerce

•Microsoft Certified Professional in Visual Basic

•SkillPath administrative training

•Oracle Database Administration



Contact this candidate