Sql Database Administrator/oracle Dba Resume
Arlington, VA
SUMMARY:
- Accomplished Oracle 11g - certified(OCA,OCP),CompTIA Security Plus, MICROSOFT SQL SERVER (MCP,MCSA, MCSE), Data Warehouse(Big Data) with expertise in performance tuning, Index turning, crisis management, and high availability to increase reliability, maximize productivity, and introduce system efficiencies, Expertise with Backup, Restores, T-SQL, SSIS, SSAS, SSRS, PowerShell script.
TECHNICAL SKILLS:
Operating Systems: UNIX - Solaris, HP UX, AIX, Red Hat 4 Linux 2.6.9, and Windows Server Nt/2000/2012.
RDBMS: OracleV8i, V9i, 10g Releases 1 and 2, 11g, MCP Sql server, MCSE Sql server
Hardware: HP 9000 Series, HP Superdome, Sun Ultra 4500/6500/10 K, HP DL585/AMD
Tools: SQL*Plus, EM, Grid Control, SQL*Loader, RMAN, Tracing, Explain-Plan, AWR, Scheduler, Data Pump, Shell Scripting, ASM, Sql Management studio, Reporting manager, Sql Data Tools, Visual studio 2013
PROFESSIONAL EXPERIENCE:
Confidential, Arlington, VA
SQL Database Administrator/Oracle DBA
Key Responsibilities Handled:
- Support a four-terabyte data warehouse; play a lead role in enterprise-wide database optimization and instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries. Work actively on new 11g features such as ASM, ADDM, and ASH, performance statistics collection, and fine tuning database wait events. Provide on-call support for enterprise databases.
- Installed, Configured and Administered SQL Server 2012/2008/2005 Servers in Production, QA and UAT Environments.
- Successfully implemented Database Mirroring in SQL Server 2012/2008R2 for high availability on two VMware servers in the Window Sever 2012.
- Managing SQL Server database through multiple product lifecycle environment,
- Configure and manage database maintenance plans for update statistics, database integrity check, backup operations, system health, performance, indexing updates
- Installed and Configured 2- node High availability SQL Active/Passive clusters.
- Conducted database performance monitoring and applied data modeling techniques to implement support efforts integration and performance expectations.
- Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
- Performed Administrative tasks in SQL Server using PowerShell.
- Installed SQL server instance on VMware server.
- Managing multiple databases (Oracle, SQL server jobs) using PowerShell script.
- Providing 24/7 support for critical production systems.
- Implemented database refresh using full export for table level and full database defragmentation, resulting improved performance and effective space management using PowerShell script and also performing disaster recovery for failed windows services.
- Developed many crystal reports using T-SQL, JDE Report Design.
- Managed and resolved design issues during development stage. Worked closely with developers.
- Generated reports from the database using PL/SQL and SQL.
- As lead architecture with experience with T-SQL, SSIS, SSAS, SSRS.
- Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows server 2012 and SQL Accounts).
Environment: Microsoft Server 2012/2008/64 bit, Microsoft SQL Server 2012, Microsoft SQL Server 2010, Microsoft SQL Server 2008, RedHat Oracle 11g, Oracle 10g.
Confidential, Chantilly, VA
Lead SQL DBA /Developer
Key Responsibilities Handle
- Managed backup recovery, multiple data bases and user right in Windows server
Assisted in installation, assembling and maintenance of SQL server and related versions Implemented modifications for database structures and database objects such as triggers and stored procedure
- Installed and configured Microsoft SQL node Clustering (Active/Passive)
- Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
- Implemented and configured Transactional, Snapshot and Merge replication
- Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
- Implemented and developed numerous VB applications including a time card system
- Created process that loads the aircraft's historical data from FoxPro database to Oracle 11g database
- Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory and monitoring locks in PowerShell Script.
- Formulated recommendations about optimal storage configurations for senior management.
- Contributing my skills in T-SQL, PowerShell, VBScript, SSIS, SSRS and SSAS and MS SQL server as a Microsoft SQL server DBA.
- Identified and reduced/eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
Environment: MS SQL-SERVER 2012, 2008, SQL Diagrams, MS Windows 2012 Sever, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, PowerShell Scripting.
Confidential
JR.SQL Server DBA/Developer
Key Responsibilities Handled:
- Involved in creating Stored Procedures, views, tables, constrains.
- Created stored procedures and triggers for Data consistency.
- Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
- Rebuilding the indexes at regular intervals for better performance.
- Using log shipping for synchronization of database
- Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Moved files between the File Groups and partitioned the tables to improve the performance.
- Monitoring SQL server performance using profiler to find performance
- Wrote complex stored procedures to process employee’s requirement and generating.
- Worked on complex T-SQL statements, and implemented various codes and functions.
- Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
- Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
- Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines