We provide IT Staff Augmentation Services!

Database Team Lead/ Database Architect Resume

VA

SUMMARY:

  • Over 13 years’ experience as Sr Database Architect/Lead DBA/Principal Database Engineer with a broad range of experience in the design, development, integration, support of SDLC (Software Development Life Cycle), production support and support for Dimensional Data Modeling with knowledge on cubes and Analysis services, and Performance tuning and improvement of mission critical data - driven applications for large organizations in both the private and federal sectors.
  • Experience in MS SQL Server Installation including SQL Server 2005, 2008, 2012, 2014, 2016, Sybase Adaptive Server, SQL Server Failover Clustering and High Availability.
  • Worked as a Database Team Lead/Database Architect for 5 years and handled Complex SQL Server and MYSQL Developmental and Administration issues.
  • Leading Production Support team of medium and large-scale web-based enterprise level HHS applications and client server applications that includes data support for 4 HRSA bureaus (OFAM, BHW, BPHC, and HAB).
  • Implementation of High Availability features of SQL 2012/2014 and took advantage of Read-only Secondary Server for Highly readable workloads and Automatic Failover technology.
  • Experience in Migration from MYSQL to SQL Server 2014.
  • Leading Development and Production Support Team for DOD applications that includes data support for Branches (Air Force, Army, Navy, Marine Corps and DLA).
  • Implemented High Availability along with SQL Server Failover Clustering (FCI) to achieve High Availability and Disaster Recovery.
  • Light Experience on SQL Azure and HDInsight.
  • Light Experience in Amazon RDS.
  • Knowledge on Non-Relational Databases (Mongo DB).
  • Strong Experience in Administration and Development of SQL Server, MYSQL and Sybase Servers.
  • Experience with writing Complex SQL, Stored Procedures and Triggers and Functions.
  • Strong Experience in Conceptual, Logical and Physical data modeling for multiple projects using tools such as Erwin Data Modeler and Enterprise Architect.
  • Extensive Experience with Performance tuning, Optimization and Disaster Recovery.
  • Experience with supporting and maintaining Large and highly Critical Transactional Database (up to 800 GB).
  • Strong Experience in Dimensional Data Modeling and Complex SSIS Package in populating Dimension and Fact Tables.
  • Extensive experience with creating and administering Transactional and Merge Replication.
  • Experience with PowerShell Scripting and Automation.
  • Excellent knowledge in Troubleshooting and resolving Replication issues.
  • Establishing guidelines for a defined Database Architecture and Database Builds.
  • Excellent Analytical, Communication and Presentation skills.
  • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
  • Experience with SQL Server Analysis Services and Cubes.
  • Experience with managing 10 DBAs/SQL and MYSQL Developers and providing guidance and support to Database, Development and QA team members.
  • Worked in Team environment and worked closely with Developers, Technical Architects and Project Manager.
  • Experience in Reporting tools such as Tableau

TECHNICAL SKILLS:

RBDMS: MS SQL Server 2000/7.0/2005/2008/ 2012/2014/2016, Sybase Adaptive Server, Access 2010, MYSQL 5.6 and 5.7

NonRelational DB: MongoDB

Operating Systems: Windows 2000, 2003, 2012, 2016, Linux

Tools: Cluster Administrator, SQL Lite Speed, Erwin Data Modeler, SQL Loader, Shell scripts, Remedy, NT Performance monitor, TSM, SQL Profiler, SQL Query Analyzer, PowerShell, SVN, Idera Diagnostic Manager, TFS, MYSQL Work bench, Enterprise Architect, PAL(Performance Analysis of Logs), Visual Studio and SQL Database Project, SSIS, SSAS, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, VA

Database Team Lead/ Database Architect

Responsibilities:

  • Worked as Database Lead/Database Architect and Managed 8-10 SQL and MYSQL DBA/Developer.
  • Involved in Architect of SQL Server and MYSQL for Enterprise Solutions.
  • Experience in Migration of MYSQL 5.7 to SQL Server 2014/2016.
  • Work Closely with Business Analyst and Collect business requirement to construct initial cut of Conceptual, Logical database design and Physical database design with tool such as Erwin Data Modeler and Enterprise Architect.
  • Experience in Development and Administration of MongoDB.
  • Experience in Replica Sets and Sharding feature of MongoDB.
  • Worked as key player in Architecture/Development/Administration of SQL Server and MYSQL Database for DOD Applications.
  • Work closely with Developers and Quality Assurance Team on SDLC (Software Development Life Cycle) and Provided Guidance on SQL Server and MYSQL Architect.
  • Experience in Dimensional Data Modeling with Star, Snowflake and Galaxy Model design.
  • Experience in Complex SSIS Package for Data Warehouse and DataMart.
  • Involved in all development activities such as writing complex Store Procedure, Functions, Views and Triggers.
  • Implementation of High Availability features of SQL 2016 with Read-only Secondary Server for Highly readable workloads and Automatic Failover technology.
  • Participated in regular meeting with Customers as Database Architect and provided innovative Solutions.
  • Implemented MongoDB on small-scale projects and provided support for Maintenance and Sustainability.
  • Experience in PowerShell Scripting and Automation.
  • Provided Guidance and Technical Support to Database, Developer and QA Team.
  • Strong Experience in Database Development, Administration and Operation of OLTP and OLAP System.
  • Experience in SQL Azure and HDInsight.
  • Expert in Performance Tuning of SQL Server and MYSQL Server.
  • Experience in SSAS cubes and Tableau Reporting tools.

Confidential, VA

Principle Database Engineer/Database Architect (DBA/Developer Lead)

Responsibilities:

  • Installed and managed SQL Server 2005, 2008 and SQL 2012 on Windows 2003 and 2012/2014/2016 servers, total environment includes, 60 servers out of which 20 SQL Servers are production servers and others are development and test environment.
  • Worked as Database Architect for 4 years and involved in Architect of SQL Server for Enterprise Solutions.
  • Leading Production Support team of medium and large-scale web-based enterprise level HHS applications and client server applications that includes data support for 4 HRSA bureaus (OFAM, BHW, BPHC, and HAB).
  • Experience in Migration of SQL Server from 2005 and 2008 to 2012/2014.
  • Work Closely with Business Analyst and collect business requirement to construct initial cut of logical database design and physical database design with ERWIN Data Modeler.
  • Implemented High Availability along with SQL Server Failover Clustering (FCI) to achieve High Availability and Disaster Recovery.
  • Work closely with Developers on SDLC (Software Development Life Cycle).
  • Experience in Dimensional Data Modeling with Star, SnowFlake and Galaxy Model design.
  • Experience in Complex SSIS Package for DataWarehouse and DataMarts.
  • Plan, design, and implement application database code objects, such as stored procedures and Triggers and views.
  • Development of Complex Store Procedures, Functions and Triggers based on Development needs.
  • Provide mentorship and Guidance to junior/mid-level developers on SQL Development and Administration.
  • Involve in Performance tuning of SQL Server and Windows Server using Performance Monitor, SQL Profiler and SQL Execution Plans and Indexes.
  • Support database needs for multiple environments (development, test, QA, UAT) in a highly collaborative team environment.
  • Excellent Experience with Capacity Planning and Growth trend Analysis.
  • Assessment of SQL Environment for configuration, storage, CPU, Memory, IO, security and Maintenance.
  • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
  • Excellent Experience with Data Migration from Legacy System to New System.
  • Experience in setting up Transactional and Merge Replications and administering them in Production Servers.
  • Experience with SAN, LUN and different Raid-level.
  • Participated as a lead in the implementation of database projects that required collaboration across various infrastructure teams.
  • Analyze SQL server deadlocking, locking and blocking and troubleshoot the root cause of those issue.
  • Monitor SQL Server Performance with jobs and tools and Provide reports to senior management.
  • Experienced with change management control processes to track the change applied to production servers.

Confidential, PA

Senior SQL Server, Sybase Server DBA/Developer

Responsibilities:

  • Installed and managed SQL Server 2000, 2005 and 2008 on windows 2000 and 2003 servers, total environment includes, 112 servers out of which 70 SQL Servers are production servers and others are development and test environment.
  • Installed and maintained Active/Active and Active/Passive MS SQL clusters for production environments.
  • Extensive experience in handling large and Highly Transactional databases (800-850 GB)
  • Understanding and Implementation of Complete Process of SDLC.
  • Development of Complex Store Procedures, Functions and Triggers.
  • Involve in Database Design from Initial Phase to Physical Data Model with Erwin Data Modeler.
  • Involve in Migration of SQL Server from 2005 to SQL Server 2008.
  • Provide Guidance to Developers and QC for best Practices of T-SQL.
  • Experience in setting up Transactional and Merge Replications and administering them in Production Servers.
  • Established and maintained Transactional Replication in High OLTP environment for Reporting needs.
  • Experience in troubleshooting and resolving replication issues.
  • Excellent experience in performance tuning of SQL Servers with SQL Profiler, Database tuning advisor and Performance Monitoring.
  • Strong Experience with T-SQL and I-SQL Scripts.
  • Involved in writing complex stored procedures, Functions and Triggers.
  • Experience with creating Complex DTS, SSIS packages and administered them in production environment.
  • Experience with Visual SourceSafe for maintaining environment with Development, testing and Production.
  • Excellent experience in Database Mirroring (Synchronous/Asynchronous).
  • Experience in troubleshooting Deadlocking, Locking and Blocking in SQL 2000/2005 Servers.
  • Experience in providing production support for 10 Sybase adaptive servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues.

Confidential, NE

SQL Server DBA

Responsibilities:

  • As a production and development support DBA, for 120 servers including production, test and development servers.
  • Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, applied service packs and security fix for all servers.
  • Experience with Reporting Services.
  • Experience with XML APIs.
  • Involved in setting up Transactional and Merge replication and maintained them in production servers.
  • Experience in upgrading from SQL Server 2000 to SQL Server 2005 server and tested the upgrade.
  • Experience with Merge Replication (With 4 subscribers updating/inserting/deleting) and handling conflicts
  • Worked with Large Databases (up to 800 GB) and maintained them in highly transactional environment.
  • Experienced in installing, configuring and maintaining fail over MS SQL clusters for production environments.
  • Extensive experience with Peer-to peer transactional replication and monitoring performance for all replication types.
  • Experience in creating logical and physical database design for development projects.
  • Experienced in developing reports and administering Reporting Services 2005.
  • Excellent experience with configuring logs shipping for backup purpose for 2 different projects.
  • Experience in creating backup and restore strategy and setting up the backup maintenance plans for production, test and development servers.
  • Involved in recovering SQL Server in disaster recovery solutions and created the document for disaster recovery procedures.
  • Experience in creating the DTS packages, SSIS packages to import the data from different data sources like Oracle, access and text files.
  • Involved in improving SQL Server using windows performance monitor to improve the server performance and database performance-using database tuning methods.
  • Experienced with change management control processes to track the change applied to production servers.
  • Expert in writing complex T-SQL like stored procedures triggers and Functions .
  • Experience with 32-bit and 64-bit environment for SQL Server and installing ODBC drivers.
  • Involved in database capacity planning and give them advice to procure system hardware.
  • Experienced with securing SQL Server, user administration and assign the permission.
  • Experience with third-party tools like SQLLitespeed, TSM and Redgate.
  • Extensive knowledge with SAN, Lun and different Raid-level.
  • Experienced with setting up SQL Security features and maintained the user administration.
  • Assist the SQL developers to optimize the SQL queries and stored procedures.
  • Created check lists to install SQL Server, SQL Cluster, service packs installation on stand alone and cluster servers and hot fix
  • Worked in a team environment and involved in 24/7 production environment.

Hire Now