We provide IT Staff Augmentation Services!

Solution Architecture Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Associate has 13+ years of experience in the Information Technology. As part of his assignments, he has been in Database Administration and Microsoft Azure Solutions Architect - Cloud and Data Platform.
  • He has good experience in Installation and Administration of MS SQL Server 2008/2012/2014/2016, Oracle 12C on Windows Server 2003/2008/2012 /2012 R2 on cluster as well non cluster environment . Microsoft Azure platform (PaaS & IaaS).
  • Migration of current data center customer environments to Azure and develop appropriate processes such as change management for the Cloud.
  • Sql server upgrade /Migration from Sql server 2000/2005 to Sql server 2008/R 2/2012/2014/2016 & MS Azure Sql (PaaS).
  • Designing, developing and managing critical applications in Microsoft Azure platform (IaaS & PaaS) as per industry proven cloud computing and application design patterns.
  • Implement warehouse model in snowflake or star schema and physical model from logical model in AZURE SQL (DB & warehouse).
  • Knowledge of Azure Database Migration Service: Migration of on-premises SQL Server database with Microsoft Data Migration.
  • Experience in Azure Data Factory(ADF2), API Management service, Storage account, Resource group, Index advisor, Query Store, Geo-Replication, Elastic Database pool,In-Memory support & PowerShell script.
  • Knowledge of Sql azure security features-Azure Active Directory Autantication, Row-level security, Dynamic data masking.
  • Database servers monitoring via Microsoft Operations Management suits (OMS)
  • Implementing high availability withAlwaysOn Availability Groupsand failover clustering in Sql server 2014.
  • Database Encryption-TDE.
  • Oracle 12C Installation, Administration and maintenance.
  • Involve in database implementation life cycle from sizing, capacity planning, design, and implementation
  • Performance Tuning - Query and Server Level.
  • Experience in ODI designer, Topology, Operator and ODI Tools.
  • Building DR sites for existing Production environments and synchronizing them by configuring Log shipping, Transactional Replication and Mirroring.
  • Implementing ITIL processes - Incident management, Problem management, Change and Release management, Request Fulfillment and Continuous service improvement.

TECHNICAL SKILLS

Hardware / Platforms: Windows 2000/ 2003/2008/2012, 2012R2

Databases: SQL Server 2000/2005/2008 / R2/2012,2014,2016, Azure Sql server, Oracle 11g & 12C

Other Utilities: SSMS,Data tool,Hyperbac,Veritas,MS SharePoint,SCOM, BMC Remedy,SVN,VSS,Nessus,MBSA,Card Recon,Tripwire,IIS,MS Azure Portal,visualstudio.com, PowerShell script & Azure Data Factory (ADF2), Microsoft Operations Management suits (OMS),ETL-Informatica (ICS)

PROFESSIONAL EXPERIENCE

Confidential

Solution Architecture

Responsibilities:

  • Create Solution Architecture based upon Microsoft Azure PaaS Services
  • Design solution for various system components using Microsoft Azure
  • Implement warehouse model in snowflake or star schema and physical model from logical model in AZURE SQL (DB & warehouse).
  • Designing, developing and managing critical applications in Microsoft Azure platform ( PaaS).
  • Designing, developing and managing Fact and Dim tables.
  • Designing, developing, deploying automated process to ETL (Extract, transform and Load ) data from Flat files,CRM XML Query and SQL to Azure Sql DB using using Azure Data factory (ADF2) and Informatica Cloud. Platform (ICS).
  • Co-ordination with external team members and other stake holders to understand the impact of their changes to complete release work with comfort. dat halps a lot to avoid any integration issues in Explore.MS application

Confidential

Microsoft Azure Solutions Architect

Responsibilities:

  • Performing capacity planning and costing of applications considered for Microsoft Azure .
  • Designing, developing and managing critical applications in Microsoft Azure platform ( PaaS) as per industry proven cloud computing and application design patterns.
  • Install, configure and maintain Storage account, Azure File Sync, Resource group, Azure Data factory (ADf2), Azure Sql DB server, Database, SQL elastic pools,, Index advisor, Query Store, Geo-Replication.
  • Migrate on-premises SQL Server database with Microsoft Data Migration Assistant: Install Database migration Assistant, Create migration, configure Source and target, Create script and migrate data.
  • Designing, developing, deploying automated process to ETL (Extract, transform and Load ) data from Flat files residing at Azure File Sync to Azure Sql DB.
  • Configure Integration Runtime Setup, Schedule SSIS, create Triger, maintain and monitor Sql jobs (Store proc & SSIS) using Azure Data factory (ADF2).
  • Create pipeline,DataSets,Copy Data, Linked services using Azure Data Factory (ADF2) and PowerShell scripts.
  • Create Azure Active Directory and maintain Sql login, role and permission using Azure Active Directory.
  • Create and maintain Users and their permissions using Microsoft Azure portal.
  • Prod Database servers monitoring via Microsoft Operations Management suits (OMS)
  • Improve warehouse and DB performance using Partitioning, Sharding and other DB concepts.
  • Implement & manage warehouse model and ensure data synchronizations across multiple geo locations
  • Work with infrastructure team to handle security and firewall and ensure data availability to applications.

Confidential

Sr Oracle DBA

Responsibilities:

  • Installed and upgraded the Oracle server 12C and Master Tax application tool.
  • Migrate\upgrade current Empower Oracle DB from Oracle 10g to Db server Oracle 12C.
  • Design and build Oracle Database migration strategy, present and approve from SEI Stakeholders.
  • Worked with server team for capacity planning and build and open required firewall.
  • Develop and automate Script to Refresh Archive DB from current DB as business requirement.
  • Allocating system storage and planning future storage requirements for the database system.
  • Modify the database structure, as necessary, from information given by application developer.
  • Enrolling users and maintaining system security and controlling and monitoring user access to the database.
  • Monitoring and optimizing the performance of the database.
  • Planning and impregnation for backup and recovery of database.
  • Contacting Oracle Corporation and ADP for technical support.

Confidential

Sr Oracle DBA

Responsibilities:

  • Architecting, planning & Migrate the on premise SAP Sql Server 2008 DB size around 1.5TB to MS Azure Sql server (IaaS).
  • Designing, developing and managing critical applications in Microsoft Azure platform (IaaS and PaaS) as per industry proven cloud computing and application design patterns.
  • Support Development, Testing, QA and Production environments on Azure.
  • Support & Maintain the SAP environment on Azure with Managed Shared Services.
  • Refresh lower environments with production DB back as needed.

Confidential

Sr SQL DBA

Responsibilities:

  • Design and build Database migration strategy, present and approve from SEI Stakeholders.
  • Involve in Database Servers capacity planning.
  • Prepare Cutover plan and L3 Plan and execute during Go live.
  • SQL Server Installations, Administration v 2008R2,2012.
  • Implement SQL 2014 AlwaysOn Availability Groups and Failover Clustering
  • Implement Database Encryption TDE
  • Migrate DB server from Sql server 2000 to Sql server 2014
  • Migrate DTS to SSIS
  • Performance Tuning - Query and Server Level
  • Database Deployments per Change Management.
  • Developing database object - Stored procedure,Table,View.
  • Develop, build and install Sql server report RDL.
  • Work with other Confidential vendors to get their product install and manage in Confidential environments.
  • Prepare weekly status report-Complete, Ongoing and future work estimation and present with 7-Elevn IT team.
  • Prepare KT document and Handover to Database Support Team.
  • Prepare HLE, effort estimation for onshore-offshore for other up-coming database migration/upgrade projects.

Confidential

Sr SQL DBA

Responsibilities:

  • SQL Server Installations, Administration v 2000,2005,2008,2008 R2,2012,2014
  • High Availability Solutions - Clustering, Replication, Log Shipping, Database Mirroring
  • SQL 2012 AlwaysOn Availability Groups and Failover Clustering
  • Handle emergency bridge
  • Deploy and maintain SSRS, SSAS, SSIS, DTS
  • Performance Tuning - Query and Server Level
  • Production Issues Troubleshooting
  • Database Deployments per Change Management-ITG Proess.
  • 24X7 Tier II support
  • Incident Management

Confidential

Sr SQL DBA

Responsibilities:

  • Handling production On-Call Support
  • Installation & configuration of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in Standalone as well as Clustered environment.
  • Building DR sites for existing Production environments and synchronizing them by configuring Log shipping, Transactional Replication and Mirroring in SQL Server 2000/ 2005/2008.
  • Troubleshooting Jobs \ DTS \ SSIS packages which are failing frequently and fixing them
  • Data Collection and analysis for SQL Server Consolidation and Decommissioning
  • Handling Daily Incident Tickets and Day to Day SQL Issues.
  • Working on Disk Space monitoring and troubleshooting for Data files and log files.
  • Working on high CPU & memory consumption alerts and troubleshooting
  • Pre and post work for rebooting servers for patch release.
  • Handling Emergency Bridges to resolve the issues
  • Monitoring Physical Server, SQL Instances and Databases SCOM
  • Performance Tuning.
  • Monitoring and resolving Incident/change request Tickets
  • Working on Standard/Emergency/Bundle releases including deployment of DTS,SSIS and SSRS to servers.
  • Preparing Daily Dashboard, Weekly incident report to present in client meeting.

Confidential

Team Member

Responsibilities:

  • Database server migration from Windows server 2000 to Window server 2008 to cross data center.
  • Sql server upgrade /Migration from Sql server 2000 to Sql server 2008/R2.
  • Upgrade DTS to SSIS package
  • Sql server 2008 SP3 upgrade

We'd love your feedback!