We provide IT Staff Augmentation Services!

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

Hire Now