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