Senior Dba Architect Resume
Washington, DC
SUMMARY:
- Overall 14+ years of experience in MS - SQL Server and Oracle Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing backup/recovery strategies, Disk space management, Memory management and Performance tuning.
- Extensive experience in ETL process by using SSIS (SQL Server Integration Services) and DTS Designer in SQL Server and Oracle environments and creating reports using SSRS (SQL Server Reporting Services)
- Experienced in comparing schemas in different databases using Red Gate software
- Experience in monitoring and tuning multiple databases SQL Server and Oracle databases using MS-SQL server Administration tools (MMC) and Oracle Enterprise Manager
- Experienced in setting up Microsoft Cluster and managing SQL Server 2005/2008/2012 databases in Cluster environment
- Experience in SQL Server stored procedures, views, triggers, UDF’s and configuration of multiple instances, and clusters
- Involved in design and development of SSIS/DTS packages to load data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa
- Involved in performance tuning of very complex SQL statements and procedures using showplan and iostatic, creating named cache and binding objects
- Expertise in trouble-shooting (handling database corruption, transaction log problems, deadlocks, and Query performance problems)
- Expert in performing database consistency checks (DBCC Commands) and planning and scheduling Backup & Recovery
- Expert in MS SQL Server 2005/2008/2012 Administration, which includes Installation & Configuration on Windows 2000/2003/2008 Server
- Expert in Oracle Administration, which includes Installation & Configuration of Oracle database in stand-alone and RAC environment
- Experienced in creating ASM instance and migrating from OCF2 to ASM on Oracle 10g/11g
- Designed High Availability Databases with Oracle Standby Database, RAC
- Expert in Disaster recovery using RMAN and GALAXY Backup Systems
TECHNICAL EXPERTISE:
O/S: DOS 6.1, Windows XP/2000/2003, HP UNIX, Linux Red Hat Enterprise
Hardware: IBM PC/AT 486, Pentium, Pentium II & III
Languages: SQL, PL/SQL, HTML, DHTML, JAVA Script, VB Script, Visual Basic 6.0, Computer Graphics with OpenGL
Applications: Office 2003/2007, FTP, XML, TCP/IP
Tools: RMAN, Oracle Enterprise Manager, Visio, ERwin 3.52, Quest TOAD, Quest Schema Manager, Import & Export, Spotlight, SQL Lab Vision, ASMCMD, SQL Server Migration Assistant (SSMA 4.0), SQL Backtrack (BMC Software), DB Artisan, SQL*Loader, Reporting Services (SSRS), Red Gate, SharePoint 2007/2010, Power Shell Scripting
RDBMS: MS SQL Server (2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5), Oracle 10g/9i/8i/8, MS Access 2000/2003
WORK EXPERIENCE:
Confidential, Washington, DC
Senior DBA Architect
Responsibilities:- Prepares system requirements, source data analysis and process analyses documentation and design documentation throughout the database creation and implementation
- Identifies improvement and technological solutions for decision support services, data analytics services and data management system enhancements
- Investigates and evaluates new data analytics algorithms and technologies to support investigative data analysis requirements
- Follows processes and procedures to identify and implement process improvements
- Participates in and conducts data extraction, transformation and load code, preprocessing and post processing scripts peer reviews
- Effectively and actively communicates with the engineering team, management, and the IRS Customer
- Setup database mirroring using Always On (AG) feature of SQL Server 2012
- Experience in setup the SQL Server Clustering (2008,2012 and 2016)
- Experience in cloning the Production databases to UAT, QA, and DEV environments
- Implement policies for database migrations and consolidation
- Experience in performance tuning and database capacity planning
- Participate and implemented disaster recovery processes
- Experience in SQL Server Transparent Data Encryption (TDE)
- Experience in ETL process using Informatica and SSIS tools
- Experience in writing reports using SSRS
- Responsible to recommend and strategies to application owners on how to improve performace and scalability of their database components
- Provide architectural guidance on strategies to improve operations and monitoring of current and future implementations
Confidential, Springfield, VA
Senior DBA Developer
Responsibilities:- Analyze and define the logical and physical database structure on the project requirements
- Establish, maintain, and control the project data model and data dictionary
- Provide technical guidance to system and application programmers
- Develop, document, and enforce standards, security procedures and controls for access to ensure the integrity of database system
- Design, implement, and periodically test the backup and recovery procedures
- Direct and participate in the conceptual database design and specifications
- Perform database administration activities including but not limited to installation, configuration, backup and maintenance of the databases in multiple environments
- Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
- Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
- Ensure the reliability, serviceability, and maintainability of the system with demonstrable accuracy, privacy, and security
- Develop test plans and test data for database systems and support software.
- Serve as a primary point of contact for hardware, software and database upgrades, removing and servicing user accounts on system platform and in all databases
- Contribute in the development knowledge base
- Participate and contribute in process improvement activities at the project and corporate level
Confidential, Herndon, VA
Senior DBA Consultant
Responsibilities:- Responsible to design and implement SQL 2005/2008/2008- R2 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
- Responsible to manage SQL Server 2008-R2 databases for SharePoint 2007/2010 environment
- Responsible to optimize SharePoint 2007/2010 databases for better performance
- Interact with system administrators to allocate storage for SharePoint databases
- Familiar with SharePoint 2007/2010 site creation, manage user permissions, SharePoint Central Administrator tool
- Responsible to configure different SharePoint 2010 services and creation of SharePoint databases
- Helped migration/upgrade SharePoint from 2007 to 2010
- Interact with users to gather business requirements and build solutions based on SQL Server technologies
- Responsible to review code (stored procedures, functions, etc), approve and move into Production environment
- Responsible to review database log files to identify risks and issues. Escalate risks and issues to management and recommend solutions
- Follow pre-defined SDLC process
- Responsible to enforce database standards for coding (stored procedures, functions, triggers etc)
- Responsible to create and maintain complex SSIS/DTS packages
- Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
- Involve in creating Disaster Recovery process for SQL Server 2005/2008
- Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005/2008 databases
- Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS/DTS packages
- Involved in doing Capacity planning for business critical applications running on SQL Server 2005
- Build a process to load data using DTS and SSIS packages
- Responsible to install SQL Server software and apply patches/service packs as needed
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
- Responsible for implementation and administration of SQL Server Databases for maximum uptime
Confidential, Washington, DC
Senior DBA Consultant
Responsibilities:- Responsible to design and implement SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
- Involve in creating Disaster Recovery process for SQL Server 2005
- Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
- After mapping schemas (from Oracle to SQL Server), install SQL Server and create databases based on schema requirements
- Worked with developers to map the objects from Oracle to SQL Server 2005 migration
- Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
- Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
- Involved in doing Capacity planning for business critical applications running on SQL Server 2005
- Build a process to load data using DTS and SSIS packages
- Build reports using SQL Server Reporting Services 2005 (SSRS)
- Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
- Responsible to install SQL Server software and apply patches/service packs as needed
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
- Responsible for implementation and administration of SQL Server Databases for maximum uptime
- Provide 24 hours on-call support for SQL Server databases
Confidential, Washington, DC
Senior DBA Consultant
Responsibilities:- Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
- Involve in creating Disaster Recovery process for SQL Server 2005
- Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
- Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
- Experienced in managing SQL Server databases in Cluster environment
- Involved in doing Capacity planning for business critical applications running on SQL Server 2005
- Build table partitioning for big tables to improve performance
- Build a process to load data using DTS and SSIS packages
- Build reports using SQL Server Reporting Services 2005 (SSRS)
- Normalization, data modeling, data transformations, mapping, and data mining
- Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
- Backup and restore databases utilizing maintenance plans, T-SQL, or third party tools BackupExec
- Responsible to install SQL Server software and apply patches/service packs as needed
- Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
- Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
- Determine database movement strategies across servers using Red-Gate software
- Help analyze performance issues on existing systems and aid developer to optimize stored procedures
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
- Responsible for implementation and administration of SQL Server Databases for maximum uptime
- Provide 24 hours on-call support for SQL Server databases
Confidential, Jacksonville, FL
Functional DBA Team Lead
Responsibilities:- Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, QA, and PROD
- Experienced enough migrating/upgrading SQL Server database from SQL 2000 to SQL 2005
- Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
- Worked with developers to map the objects from Oracle to SQL Server 2005 migration
- Experienced on migrating/upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
- Experienced in managing SQL Server databases in Cluster environment
- Involved in doing Capacity planning for DW and other projects
- Build table partitioning for big tables to improve performance
- Build a process to load data to Data Warehouse using DTS and SSIS packages
- Build reports using SQL Server Reporting Services 2005 (SSRS)
- Normalization, data modeling, data transformations, mapping, and data mining
- Involved in taking BACKUPS and restoring process of Development, QA and Production Databases
- Backup and restore databases (size up to 1 TB) utilizing maintenance plans, T-SQL, or third party tools Commvault (similar to LiteSpeed)
- Responsible to install SQL Server software and apply patches/service packs as needed
- Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
- Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
- Determine database movement strategies across servers using Red-Gate software
- Reverse engineer to draft ERD of databases used by a third party application ERWIN/VISIO
- Help analyze performance issues on existing systems and aid developer to optimize stored procedures
- Manage database security including encryption, server/database logins and roles
- Used SQL Profiler extensively to monitor the performance of the application/data migration and databases
- Design, implement, and maintain Oracle and SQL Server Databases
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on both Oracle and SQL Server
- Responsible for implementation and administration of SQL Server/Oracle Databases for maximum uptime
- Involve in creating Disaster Recovery process for both SQL Server and Oracle databases
- Involved in complex code reviews and code walkthroughs of various projects
- Provide 24 hours on-call support for both SQL Server and Oracle production databases
- Experienced in creating, implementing, and managing transparent data encryption in Oracle databases
- Experienced in creating and managing Oracle databases on 2 node RAC environment
- Experienced in creating and managing ASM instances in RAC and stand alone environments