We provide IT Staff Augmentation Services!

Dba Resume

0/5 (Submit Your Rating)



  • Oracle Database SQL Certified and Over 7+ years of experience in various Information Technology segments, Offering over 7+ years of Professional experience in RDBMS, including MS - SQL Database Administration and Oracle, Proficient in SQL Server DBA in Windows operating systems, Database Migrations, Database Capacity Planning, Automated backup Implementation, and Performance Tuning
  • Experienced in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively
  • Experienced in Linux/Unix shell Scripting
  • Strong Knowledge of Backups,Restores,Recovery Models, Database Shrink Operations, DBCC Commands
  • Experienced in managing and maintaining the Data Center and Disaster Recovery of Databases
  • Good Knowledge and practical skills in Financial/Capital markets data
  • Experienced in using DMV and dynamic management function for finding out Long Running Queries
  • Excellent knowledge and skills in Data Mining tools and Techniques
  • Ensured that production servers and databases were available for a 24/7 operation
  • Experienced in formulating business requirements and mapping source data to logical and physical database designs
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers


Databases: MS-SQL Server 2005/2008/2012 R2, Oracle 9i

Operating Systems: Windows, Windows Server, Red Hat Linux

Languages: SQL, PL/SQL, T-SQL,C, C++ and Java

SQL Server Tools: Profiler, DTA, SSMS, SAC, SSCM, PrefMon, DMVS

Other Tools: Data Warehousing, RMAN, ASM, Oracle Form Developer, OLTP, OLAP, Networking (VLAN, VPN, Firewall and FTP)

Other Skills: Data Mining Tools Statistical Programming in R/Weeka

Data Mining Algorithms: Apriori,K-Means Clustering, Neural Network And Decision tree

Preprocessing Data: (Data cleansing/Data Splitting to Train and Test using different methods) and Confidential Trading System


Confidential, NJ



  • Writing/debugging structured query language with complex joins
  • Analyzing structured query for problem resolution and performance optimizing and tuning
  • Strongly experienced in writing stored procedure, function and view creation
  • Working with the team on the creation of business intelligence applications
  • Creating and enforcing database development and operational standards
  • Strong attention to detail
  • Critical/strategic thinking and problem solving
  • Analyzing and documenting user information needs or business problems and determines most effective/efficient programming solution
  • Ensuring that applications and processes are well-documented, thoroughly tested, and operate reliably
  • Working and resolving database issues independently and with minimum supervision


MS-SQL Database Administrator


  • Performed server installation and configuration for MS-SQL Server 2005/2012 R2
  • Database administrating and performance tuning using different tools and techniques
  • Upgrading MS-SQL server from to 2012 R2
  • Analyzed and monitored the performance statistics of production databases based on the gathered data from the maintenance processes running against production server (i.e. MS-SQL Server maintenance jobs, performance monitor, profiler, etc.) including periodical reviews on the instigated thresholds against the loads on the server as the basis for capacity planning
  • Migrating data across different databases and servers
  • Windows Batch Processing and handling multiple application scheduler
  • Developed stored procedures, functions,triggers and Views using T-SQL
  • Performed all database related performance tuning and optimization as necessary based on the gathered statistics like improving and revising poorly written queries, rebuilding/updating table indexes and statistics, performing database cleanups and archives, reconfiguring MS-SQL Server’s default configuration, and other database tuning processes that help to improve the performance of the system
  • Configuring Database mirroring and replication between primary production servers and standby servers
  • Checking space monitoring, Index Defrag, Update statistics, Log shipping between primary production servers and standby
  • Maintaining and managing Data center and Disaster Recovery sites
  • Managed database users and security by granting/revoking appropriate logins and permissions for individual users and applications.
  • Performed periodical review/audit of who has access on production databases and what type of rights the users possess to prevent unauthorized access to production data based on company requirements.
  • Refresh/Cloning of Database and applications for development and testing purpose
  • Worked closely with the database users, application developers and network administrator to provide direction in identifying and resolving production database issues
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Complete documentation about the database. Recovering the databases from backup in disasters
  • To analyze long running slow queries and tune the same to optimize application and system performance
  • Extensively worked in PHP and Wamp Server to generate financial reports from the database for the clients and organization
  • Worked closely with ASP.NET Developer to redesign existing Trading System
  • Updated and monitored Streaming Traded data into website
  • Using FTP client to upload and download files from website

Environment: MS-SQL server 2005/2012 R2, DAS, MS-SQL Server Management Studio, SQL, Windows Server 2005/2012, Wamp Server and PHP,ASP .Net, Real Time Data Streaming,DNS,VPN




  • Installed, Administration and Maintenance Of SQL Server Instances
  • Create User and assigned permissions based on the level of database access the user would need
  • Created linked servers to SQL servers and other database such as ORACLE, ACCESS etc
  • Designed Database Backup and Restoration Strategy
  • Writing Stored Procedure using T-SQL to automate certain process and producing reports as per client needs
  • Created Database Backups, Monitor those backups to ensure being performed regularly
  • From time to time recover the database to a specific point of time, as per requests
  • Setup High-Availability as part of Disaster Recovery Strategy for the Databases achieving through Database Mirroring, Log Shipping and Replication
  • Troubleshoot SQL Server services outages as they occur, including after hours and weekends
  • Monitoring and performance tuning; Physical Server Level, Database Level and Query Tuning and optimization
  • Documenting Process, Procedures and Major changes to SQL Server
  • Apply service packs
  • Prepared DFD's & Entity Relationship(ER) diagrams.
  • Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming.
  • Extensively worked on Dynamic Management Views in SQL Server 2005.
  • Managed the migration of SQL Server 2005 databases to SQL Server 2008
  • Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on DBCC commands and Dynamic Management Objects
  • To set up SQL Server configuration settings for better server management
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript,, Windows 2000, Windows 2003 Server, MS-Access.


Oracle DBA


  • Installed, configured and upgraded of Oracle Server Software and related products
  • Established and maintained sound backup and recovery policies and procedures as per organization demand using RMAN
  • Automated hot backups using a combination of Incrimental,Differential and Full RMAN backups
  • Implemented and maintained Oracle 9i Data Guard/standby databases for fail-over purposes and for disaster recovery
  • Patching and Upgrading Oracle databases
  • Designed, Developed and modified Oracle Forms using Oracle Form Developer Suite
  • Wrote stored procedure and triggers on the Oracle Forms
  • Maintained of production database and development database which includes tablespace management, user creation and assigning privileges and roles to users etc
  • Proactively monitored database health and taking preventing or corrective action as required
  • Performed database tuning and Performance Monitoring
  • Setup and maintains documentation and standards
  • Debugging, Troubleshooting Oracle PL/SQL Packages, Stored Procedures and Functions
  • Analyzing and Validating database objects
  • Maintained archived data on appropriate storage devices
  • Maintained and created standby databases using Data Guard and RMAN
  • Unix/Linux Shell Scripting
  • Data loading using SQL*LOADER, Logical backups using full Export/Import and DATAPUMP
  • Oracle Database Cloning and Refreshing using User Managed Backup and RMAN tool
  • Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Monitored the production Oracle alert logs for database errors
  • Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, and ADDM
  • Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL, Data Guard
  • Monitored system resource availability and responded to system memory and data issues
  • Work as part of a team and provide 7X24 supports when required

Environment: Oracle Database 9i, Linux/Windows Operating System, Unix/Linux Shell Scripting, RMAN, ASM, SQL Plus, SQL Loader

We'd love your feedback!