We provide IT Staff Augmentation Services!

Sr. Database Administrator/ Cloud Architect Resume

PA

OBJECTIVE

  • Over 11 years’ experience as MS SQL Server and Oracle DBA, MSBI, SSIS Packages, Data Architecture, Database Design, Implementation and System Administration using Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012 & 2014, 2016 SSIS, SSRS, BI, Oracle 12c/11g/10g. Proficiencies in AWS Cloud Solution.

SUMMARY

  • Strong Hands on experience in MS SQL Server/ORACLE Installation/, SQL Server Clustering, Performance tuning, Backup/recovery, Query Optimization and Security.
  • Expertise with AWS (Amazon Web Services) including configuring and hosting applications
  • Experience in Validation procedures comply with FDA rules.
  • Worked as both Production DBA and Development DBA.
  • Team player with excellent communication skills and positive attitude
  • I have 5+ Yrs. of experience on SSIS & SSRS.
  • Worked well independently as well as in team - oriented environments.
  • Experience with DB monitoring and performance tuning tools and reports, i.e. Foglight, Spotlight .
  • Experience with installing and supporting SharePoint.
  • Strong experience in mentoring team members and writing documentation.
  • Experienced in developing frameworks and procedural polices towards a better Database Design.
  • Establishing guidelines for a defined architecture and database builds.
  • Experience with HealthCare, Education, Financial Industries.
  • Establishing Rules in the form of Stored Procedural Code, enforcing a certain naming structure for database tables and objects.
  • Experience in supporting huge databases and troubleshooting the problems.
  • Extensive knowledge of RDBMS concepts.
  • Excellent analytical and communication skills.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Database Administrator/ Cloud Architect

Responsibilities:

  • Administering multiple SQL server database instances from versions 2014/2012 and monitor all SQL server database instances using Dell/Quest Spotlight software and participated in on-call rotation.
  • Installed, configured SQL Server/SSRS 2012/2014 on windows server platform.
  • Involved in disaster recovery - Rebuild servers in data center, restore the backup from the library, closely work with business analyst to collect the requirements & make the systems available ASAP and provide 24 X 7 dedicated support to all Production, Test and development servers
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
  • Write TSQL and SQL scripts, SSIS and developing SQL Server Reports on SSRS Tuning the SQL Server and databases on production.
  • Responsible for extract the data from Oracle to MS SQL Server databases
  • Responsible to migrate MS Access 2007 databases into MS SQL Server 2014 databases
  • Responsible for Logical & Physical Database Design and Implementation Data Modeling, SQL Server and maintain Data model
  • Responsible for database backup & restore from development to production systems
  • Involved in tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults development
  • Used DBCC to check physical and logical consistency of the database and Rebuild indexes
  • Responsible for Stored Procedures optimization and Performance tuning
  • Extensively used BCP to import & export data from flat files to MS SQL Server databases.
  • Used Oracle EXP/IMP to export data out and in from Oracle DB.
  • Performed system analysis on new and existing applications. Assisted senior developer in design, development and maintenance of application. Participated in Object-Oriented Analysis and Design using UML and Patterns.
  • Work with developer giving out solution and recommendation to improve both application and database performance.
  • Configured for accept the Automatic SQL Tuning Advisor recommended SQL profiles if it improves performance at least by three fold.
  • Document and Create project plans for customers to migration into AWS.
  • Manage Oracle DEV, TEST, and PROD environments in AWS.
  • Setup site-to-site VPN from on-premise to AWS VPC.
  • Setup backup’s strategies for RDS DBs and VMs.
  • Developed backup strategy; scripts for running RMAN Hot, incremental and logical backups (EXPDP) using passwords stored in secure external password store and RMAN repository catalog. Tested database recover procedures to bring back databases using backups.
  • Migrated Oracle DBs/instances to AWS servers.
  • Refresh Test, Development databases with copies of production database using either RMAN duplicate database or Oracle Import dump utility (IMPDP) depending on the size of database.
  • Educating client team members on the new technology solutions that are being introduced.
  • Vendor coordination.
  • Manage AWS Hybrid cloud infrastructure and help clients in identifying the right hardware & software solutions for on-prem, cloud and hybrid applications.
  • Implementing proof of concept solutions to establish a working understanding of new solutions and confidence in them.
  • Manage various AWS migration projects and support after migration.
  • Manage AWS cloud servers for customers. Used Anisble to automate several tasks.

Confidential, VA

Lead MS SQL DBA/ Senior Systems Engineer - AWS

Responsibilities:

  • Collect customer requirements to design and implement AWS Cloud solutions.
  • Utilization of AWS GovCloud features such as EC2, VPC, S3, RDS, and CloudWatch to engineer, deploy, and sustain Amazon AWS environments.
  • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark
  • Prepared DFD's & Entity Relationship( ER ) diagrams.
  • Involved in Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
  • Transferred the data ( ETL ) to Data warehouse (Informatica) by SSIS.
  • Extensively worked on Dynamic Management Views in SQLServer 2012.
  • Installed, authored, and managed reports using SQL Server Reporting Services.
  • Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, User defined functions, Indexes, and Constraints.
  • Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
  • Experience in working with ETL operations between different sources like Oracle/Access/Excel etc., using SSIS, DTS.
  • Experience in creating the configuration files to deploy the SSIS packages.
  • Managed the migration of SQL Server 2008 databases to SQL Server 2012.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Involved in Unit Testing the SSIS packages with respect to its flow and performance issues.
  • Involved in exporting or importing data from other data sources like flat files using Import/Export through DTS , SSIS.
  • Involved in Solving the Bugs Reflected by the Testing team.
  • Monitored SQL Server performance using SQL Profiler to find performance and dead locks.
  • Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Involved in rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Involved in analyzing long running slow queries and tuning the same to optimize application and system performance.
  • Set up SQL Server configuration settings for better server management.
  • Performed remediation of identified security findings that result in a Plan of Action and Milestone(s) (POAMs).
  • Responsible for Identify, remediate and update all account management issues, policies and procedures necessary to fix and sustain compliance
  • Performed Administrative tasks in SQL Server using PowerShell
  • Creation of New domain Logins and Granting privileges to users/Groups and objects.
  • Used DBCC to check physical and logical consistency of the database and Rebuild indexes.
  • Monitor windows Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
  • Responsible for Query optimization and Performance tuning.
  • Managed AWS VPC to contain multiple environments consisting of many public and private networks.
  • Use of Security Groups to control EC2 Instance inbound access between multiple instances, networks, and end users.
  • Prepared the project management and technical documentation.
  • Completed documentation about the database. Recovering the databases from backup in disasters.
  • Provide support to clients to answer questions or troubleshoot issues.
  • Solid troubleshooting skills and exceptional ability to work in a cooperative team environment to formulate complex technical security solutions.
  • Creation of system documentation to internal team and clients to communicate processes, issues, and guidance

Confidential, Richmond, VA

Sr. MS SQL DBA

Responsibilities:

  • Responsible for MS SQL Server 2008 R2 & 2012, Service pack & hot fix installation, configuration, tuning and provide 24 X 7 dedicated support to all 112 Production, development and Active Passive clustered servers.
  • Setup SQL2012 AlwaysOn for 24/7 critical patient safety system between datacenters.
  • Configured Failover Cluster Instance (FCI) & SQL 2012 AlwaysOn Technologies for 24/7 critical system between two datacenters.
  • Setup and configure Windows Server 2012 Windows Server Failover Cluster (WSFC) and AlwaysOn (HADR) SQL 2014 Availability Group with Listener on Amazon Web Services (AWS).
  • Managing SQL Server using PowerShell Scripts.
  • Responsible for Logical & Physical Database Design and Implementation Data Modeling, SQL Server and maintain Data model using ERWin
  • Worked on writing complex T-SQL queries, Sub-queries, Dynamic SQL queries.
  • Experience in development of Data Warehouse for both dimension tables and fact tables by initial load/ongoing load process using SCD/Merge/CDC, Parent/Child SSIS packages.
  • Experience with Normalization and De-normalization processes.
  • Responsible for all Production SQL servers in the data center, server maintenance, implement change control in QA & Production and sync the DR servers with production.
  • Upgraded the SQL 2000 & 2005 to SQL server 2008 R2 & 2012 servers.
  • Configured Foglight to monitor SQL instances and generate reports. Also, configure it to integrate with Ticketing system, ServcieNow.
  • Created the logical and physical data modeling using Erwin tool.
  • Installed, configured and maintained SQL Server 2008 R2 fail over cluster servers.
  • Configured and maintain transactional, snapshot and merge replications
  • Setup Linked Server, Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
  • Configured log shipping from production system to stand by server.
  • Responsible for Stored Procedures optimization, Performance tuning & index tuning
  • Extensively used DTS,BCP,BULK INSERT to import & export data from flat files, excel and MS Access to MS SQL Server databases
  • Created Backup strategy for production and development environment. Responsible for database backup & restore, monitor production servers activity, problem solving, scheduled jobs, SQL Server Error Log, space usage.
  • Assist the SQL developers to optimize the SQL queries and stored procedures.
  • Installed SQL Analysis services, extracted the data from Oracle, Access and text files and developed the Cubes.

Confidential, Northern VA

Sr. MS SQL DBA

Responsibilities:

  • Responsible for MS SQL Server 2000, 2005, 2008, 2008 R2, 2012 Service pack & hot fix installation, configuration, tuning & make the systems available ASAP and provide 24 X 7 dedicated support to all Production.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from various sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Excellent hands on managing and automating Control flow, Data flow, Events and Logging programmatically for SSIS packages.
  • Hands on experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
  • Installing, configuring, testing and administration of RDBMS database clusters.
  • Performed Administrative tasks in SQL Server using PowerShell.
  • Prepared the project management and technical documentation.
  • Complete documentation about the database. Recovering the databases from backup in disasters.
  • Provide support to clients to answer questions or troubleshoot issues.
  • Solid troubleshooting skills and exceptional ability to work in a cooperative team environment to formulate complex technical security solutions.
  • Creation of system documentation to internal team and clients to communicate processes, issues, and guidance
  • Setup and configure Windows Server 2012 Windows Server Failover Cluster (WSFC) and AlwaysOn (HADR) SQL 2014 Availability Group with Listener on Amazon Web Services (AWS).
  • Installed SQL Windows/VERITAS Clustering for production environment, Setup mirroring between datacenters/servers and configured transactional and Snapshot replication.
  • Responsible to execute SQL Server DBAs team, C apacity planning, sizing, monitoring Disk I/O, Server Rebuild & migration .
  • Created Standard Operating Procedures (SOP) for SQL Server install, upgrade, apply patch and SQL clustering.
  • Implemented and extend the auditing capabilities of Microsoft SQL
  • Responsible for database backup & restore, monitor production servers activity using third party tools like IDERA and Spotlight, Foglight, scheduled jobs, SQL Server Error Log, space usage.
  • Work with Oracle team to implement the business rules and developed logical and physical database design.
  • Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
  • Created Backup strategy for production and development environment. Responsible for database backup & restore, monitor production servers activity, problem solving, scheduled jobs, SQL Server Error Log, space usage.
  • Assist the SQL developers to optimize the SQL queries and stored procedures.
  • Installed SQL Analysis services, extracted the data from Oracle, Access and text files and developed the Cubes.
  • Extensively used BCP/BULK INSERT/DTS to import & export data from flat files to Sybase & MS SQL Server databases
  • Work with third party vendors to get & send the data via ftp in zip format and load the data in to MS SQL Server databases.

Hire Now