SUMMARY

• 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

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, NJ

DBA

Responsibilities:

• 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

Confidential

MS-SQL Database Administrator

Responsibilities:

• 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

Confidential

MS-SQL DBA

Responsibilities:

• 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.

Confidential

Oracle DBA

Responsibilities:

• 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