Sr. Devops Architect | Dba | Cloud Resume
Dallas, TX
SUMMARY
- Designed Custom Transactional Replication for SQL to handle bulk transactions between OLTP and OLAP environments to transfer high volume data without queuing mechanism. (2 TB a day).
- Specialized in designing cost effective solutions.
- Developed and deployed in - house ChatOps process using Slack & Errbot and designed custom tasks in Python & PowerShell.
- Migrated on-prem databases and applications to Azure environment with users and access.
- Hands on experience using Docker for windows as container services.
- Specialized in setting up Azure RM Templates for automating server builds dynamically.
- Automating flat files import/export from SFTP SQL using C#, CMD Shell, TSQL & PowerShell by applying business rules to raw data.
- Designed and developed custom DevOps process for TFS build and deployments to prod and non-prod environments for .Net and database environments.
- Automated .Net code deployments to Azure environment.
- Automated provisioning of SQL Servers using Docker Images for non-production environment.
- Developed CI/CD systems for database and application from on-premises to Cloud using Docker.
- Azure API Management, Security, Cloud-to-Cloud Integration (Public, Private)
- Develop powershell scripts and ARM templates to automate the provisioning and deployment process
- Provide technical guidance on building solutions using Azure PaaS and other services
- Troubleshoot and identify performance, connectivity and other issues for the applications hosted in Azure platform
- Responsible for collaborating on and setting cloud vision; providing thought leadership in cloud infrastructure and cloud services architecture to meet operational objectives for cloud solutions
- Configured Centralized SQL 2016 SSRS Server to host reports for multiple ASP & MVC applications with secured authentication.
- Optimized and enhanced CRM pages and reduced page load time up to 90% using advanced JavaScript techniques and Pagination.
- Designed and architected AWS environment using EC2, S3, Glacier, IAM etc., to set up PaaS in Cloud.
- Building 2 Node multi subnet Windows & SQL Cluster from scratch using Win 2016, SQL 2016 SP1 CU6 for AlwaysOn set up.
- Upgraded TFS Server from 2005 => 2015 without any issues.
- Developed and maintained dynamic data upload from CRM application to database from both ASP and database sides.
- Migrated SQL Server(s) from SQL 2008 SP2 => 2016 SP1 successfully.
- Designed and configured Centralized Database Maintenance and Monitoring for different versions of Prod and Non-Prod Database servers from scratch with Graphical Email & Text Alerts.
- Installing and configuring Splunk for centralized log management and analysis for multiple servers.
- Optimized long running queries to access big data sets from hours to secs using Advanced TSQL.
- Over 14 years of IT experience architecting In house and Cloud environments using AWS & Azure environments.
- Responsible for collaborating on and setting cloud vision; providing thought leadership in cloud infrastructure and cloud services architecture to meet operational objectives for cloud solutions
- Hands on experience developing console and web applications using C#, ASP.Net, HTML, JQuery, JavaScript etc.,
- Experience in upgrading SQL Server from version 2005 to 2008/R2/2012/2014/2016.
- Strong experience in configuring, maintaining, and troubleshooting Microsoft based production systems.
- Setting up CI/CD for .NET projects experience. Manage, develop, build CI/CD pipeline using Centralized Cross-Platform PowerShell environment.
- Have good experience with partitioned schemas, partitioned tables and indexes, creating file groups usingSQL Server 2008/2012/2014/2016.
- Good experience with implementing DR solution, High Availability of database servers using DatabaseMirroring, Replication and Log Shipping.
- Experience in Data Migration Management and Maintaining Large Data Sets.
- Designed and built 2 node multi-subnet cluster from scratch and implemented SQL 2016 Always On for OLTP databases.
- Hands on experience working with High Volume Databases which sizes > 10 TB.
- Hands on experiences creating, deploying and debugging console & web applications using .net technologies.
- Experience in implementing SQL Server security and Object permissions like maintaining Databaseauthentication modes, creation of users, configuring permissions and assigning roles to users.
- Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
- Good experience with Hyper-V and System Center Virtual Machine Manager (SCVMM) tool for managingVirtual Server Infrastructure.
- Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
- Installed, configured Slack with Hubot for ChatOps and team communication and customization of DevOps.
- Exposed virtual machines and cloud services in the VNets to the internet using Azure External Load Balancer.
- Good experience in implementing Identity and Access Management (IAM) technology areas with a focus on Azure Active Directory and how it interacts with traditional on premise Active Directory and Cloud Architectures using Microsoft Graph & Graph API.
- In depth knowledge of Configuration of SSO for Web and On-premises and SaaS applications with Azure AD and Azure Application proxies, ADFS 3.0, Ping Identity, ADFS on Windows 2016, Azure AD Connect, Azure RMS, MS Intune, Health Connectors, EMS, Conditional Access, MFA and RBAC (Role Based Access Control) for organizations.
- Deployed Azure IaaS virtual machines and cloud services (PaaS role instances) into secure VNets and subnets.
- Designed and configured Azure virtual networks (VNets), subnets, Azure network settings, DHCP,address blocks, DNS settings, security policies and routing.
- Good working experience with PowerShell 3.0 and higher in windows server 2008/R2/2012/2016 environments.
- Upgraded multiple SQL Server(s) from SQL 2008 SP2 => 2016 SP1 CU6 without any issues and improved performance.
- Designed and implemented in house DevOps solutions for continuous development, deployment and testing life cycle to cloud and non-cloud servers.
- Hands on experience with Active Directory for user creation and maintenance.
- Working with different tools like SolarWinds & Splunk for Log Management and troubleshooting.
- Using Splunk tools to automate deployments.
- Working with multiple technical teams, architects, security team, managers and business users, reviewedAnd documented workloads, system dependencies and business requirements. Mapped workloads to the capabilities of Microsoft Azure for public, private and hybrid clouds.
- Experience with installing and configuring SSL certificates on web servers and enabled secure (https)transactions.
- Hands on experience with designing, architecting and configuring database environments in SQL Azure &Amazon Web Services (AWS).
- Extensive experience in writing Distributed Queries between SQL Servers by creating linked servers.
- Experience with handling data migration between different database environments like SQL MySQL /Oracle SQL / SQL Azure.
- Experience in implementing different types of Replication Models like Snapshot, Merge and Transactionaln basis of business specification.
- Good exposure writing TSQL queries, Stored Procs, Triggers, Functions, Constraints, Indexes,Performance Tuning, Capacity Planning, PowerShell scripts for monitoring.
- Experience in performing integrity checks. Methods include configuring the database maintenance planwizard and DBCC utilities.
- Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, indextuning wizard.
- Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long runningqueries and deadlocks.
- Experience in applying patches and service packs to keep the database at current patch level.
- Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.
TECHNICAL SKILLS
Operating Systems: Linux, Windows 2000/2003/2008/2012/2016 Server, Windows 95/98/XP/NT/7/10
Languages: T-SQL, PL/SQL, C#, ASP .Net, JQuery, MVC .Net, CSS, VB Script, XSQL, Java Script, Node.js, Edge.js, Require.js, PowerShell, Python, CMD Shell and HTML
Report Tools: MS Reporting Services
Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2010, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Database Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Splunk, FogLight, RedGate, SolarWinds, Active Directory, Active Server Roles, CA Service Desk, IT Service Catalog, Avamar, Team Track, VMWare, Connect wise, SQL Safe, Remedy, SSDT, HP Overview etc.RDBMS MS SQL Server 2005/2008/R2/2012/2014/2016, MySQL, Oracle
Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, FTP, SFTP, PowerShell, Batch Files
Database Modeling & Other Tools: Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare, SQL Trace, SCOM 2012, Docker, GIT, Jenkins
PROFESSIONAL EXPERIENCE
Sr. DevOps Architect | DBA | Cloud
Confidential Dallas, TX
Responsibilities:
- Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure
- Architect solutions using MS Azure PaaS services such as SQL Server, HDInsight, service bus, etc
- Implemented infrastructure, build and project automation using Powershell.
- Work with state of the art tools such as VSTS, Azure Resource Management, PowerShell DSC & Docker.
- Work in conjunction with IT, engineering, and business groups to understand functionality, scalability, performance, security, and integration requirements.
- Provide Cloud / Azure thought leadership through regular publications and speaking engagements
- Provide Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process
- Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure
- Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
- Exposed virtual machines and cloud services in the VNets to the internet using Azure External Load Balancer.
- Configured Database mail, linked servers in SQL server 2012.
- Programmatically accessing Azure AD through Graph API, versions of Graph API, Azure AD Endpoints, Azure AD OAuth 2.0 Best Practices, error handling, Authorization Code as well as Client Credential Grant flows and OpenID Connect usage & Azure ACLs.
- Automated database and .net deployments to database and web servers using multiple languages like C#, PowerShell, CMD Shell, Python and TSQL.
- Extensive experience working on developing Microsoft Reporting Services.
- Using Splunk for centralize log management monitoring and alerting.
- Created, configured centralised Log management for multiple applications and database servers.
- Working with TFS to maintain source code and changes.
- Developing SSIS packages to migrate data from OLTP to OLAP servers.
- Good Working Knowledge of using SSIS & SSRS.
- Created and configured AWS services like S3, EC2, EBS, RDS, IAM etc.,
- Good working experience working with SSIS for ETL requirements and built custom solutions for using data sources like SFTP and other which old versions of SSIS don’t support.
- Created desktop applications for automating application tasks using C# and Visual Studio.
- Extensive experience with SQL query tuning and optimization.
- Working with SQLSentry PlanExplorer for checking query plans and optimizations.
- Architected and implemented in house DevOps solutions for continuous development and deployment life cycle.
- Developing Python scripts for automated delivering of encrypted messages via secure channel to a server in non-trusted domain.
- Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
- Setting up monitoring for CPU, DB Free Space, Log Space, IO and tuning the performance of databases.
- Maintaining databases as per SOX standards and generating different kinds of SOX reports for auditors.
Environment: Azure, AWS, SQL Server 2016/2014/2012/2008/R2/2008/2005, Windows 2016/2008/2012 server, Windows Server 2008(x64), BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, PowerShell, SQLSentry, ASP .Net, MVC .Net, CSS, CMD Shell, TFS, ODBC, FTP, SFTP, WFSC, VSTS, Docker etc.Chevron Nov 2013 - Feb 2014
Sr Database Architect | Admin
Confidential Concord, CA
Responsibilities:
- Responsible for migrating SQL 2005 / 08 /R2 versions to SQL 2012 with proper planning and documentation in place.
- Installed, configured Slack with Hubot for ChatOps and team communication and customization of DevOps.
- Implementing new features of SQL 2012 like Always on, Column Stored Indexes & Contained Databases in newly migrated servers.
- Working closely with Development & Application teams to guide with best practices on writing tsql queries.
- Writing Powershell scripts to make enhancements to existing functionality.
- Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well asbasic account management and troubleshooting with connectivity.
- Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
- Configured Database mail, linked servers in SQL server 2012.
- Extensive experience working on developing Microsoft Reporting Services.
- Installing, Configuring and maintaining Lite Speed for SQL Servers for backups & Restores.
- Developing SSIS packages to migrate data from OLTP to OLAP servers.
- Good Knowledge of using SSIS & SSRS.
- Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
- Working with SCOM to monitor server across all the domains.
- Maintaining databases as per SOX standards and generating different kinds of SOX reports for auditors.
Environment: SQL Server 2012/2008/R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), Windows Cluster Server, BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Remedy, Lite Speed, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP,Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC etc.Newmont May 2013 - Oct 2013
Sr Operations DBA / Developer / Lead
Confidential Denver, CO
Responsibilities:
- Responsible for supporting > 350 SQL instances which include SQL 2000 / 05 / 08 / R2 & 2012.
- Monitoring of database size and disk space in Production, Staging & Development environmentsConducted various meetings and conferences with application teams to meet corporate milestones fordatabase consolidation and data migration. Security and architectural planning issues met as well as testingand training.
- Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprisesystems of clustered and standalone HP servers in enterprise Data Centres. Patch applications.
- Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with
- Microsoft Operations Manager and backup teams.
- Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well asbasic account management and troubleshooting with connectivity.
- Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
- Configured Database mail, linked servers in SQL server 2005.
- Installed and configured Quest monitoring tools like SpotLight & FogLight.
- Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISSpackage conversions. Business Intelligence package design. Created tables and performed data imports andrestores for successful migration. Scripting development and troubleshooting for various security syncingscripts to new databases as well as creation of database roles for granting Stored Procedure rights.
- Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
- Good working knowledge of using SSRS (SQL Server Reporting Services).
- Performed Production support and on Call duties.
- Executed Change management scripts on weekly basis.
- Documented up gradation procedures from MySQL to SQL Server and Oracle to SQL Server.
- Created monitoring scripts to alert for production issues.
- Migrated Databases from MySQL, Oracle to SQL Server 2005.
Environment: SQL Server 2012/2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2000, BIDS 2005/2008, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, SSRS, CA Service Desk, IT Service Catalog, SOX, Avamar, TSQL, Stored Proc’s, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Quest SpotLight, FogLight etc.CareerBuilder Jul 2011 - Apr 2013
Senior Lead DBA / Developer / Lead
Confidential Atlanta, GA
Responsibilities:
- Management of SQL Servers, databases, storage management for databases sizing from 250 GB to 5 TB.
- Responsible for Database Administration and Performance Optimization.
- Data Migration from legacy to master tables using DTS-import and Export wizard.
- Trouble shooting Problems by using SQL server profiler.
- Administering and maintaining Clustered databases on 2 Node (Active/Passive) cluster.
- Updating with latest service packs and security patches.
- Experience working with TFS to make changes to code.
- Created views to facilitate easy user interface implementation, and triggers to enforce Dataand referential integrity.
- Created indexed views using T-SQL to increase the query performance.
- Develop Backup & Restore scripts for SQL Server as needed.
- Created reports using SQL Server Reporting services.
- Has done DBCC checks to ensure the physical consistency of the database and objects.
- Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primaryproduction servers and Standby.
Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, Team Track.
Confidential
SQL Server DBA
Responsibilities:
- Creating and maintaining various databases for Production, Development and Testing usingSQL Server 2005.
- Installing SQL Server 2005 / 08 on the server and client machines, providing connections andmanaging databases.
- Planning and scheduling backups and developing recovery procedures.
- Migration of data across different databases and different servers.
- Creating procedures, functions, and triggers, handling database performance and tuning.
- SQL Server Installation, patch application, migration of databases.
- Creation of new databases, planning the location of data, index, and Transaction log files ondisks.
- Setting up backups for the databases.
- Providing support to the Application developers on the application databases.
- Handled 24/7 Production Issues.
Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS.
SQL Server DBA
Offshore Support
Responsibilities:
- Installation, configuration and maintenance of the MS SQL Server 2000.
- Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
- Performance and tuning of SQL servers and application issues related to migration.
- Testing of applications for performance, data integrity and validation issues.
- Data Transfers between various servers using BCP and Managing Disk space on NT systems.
- Migrated oracle8i data into SQL Server 2000.
- Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
- Complete automating on NT so that the tasks are run without user monitoring.
- Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
- Administrative and Production support for various applications in all environments.
- Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency
- plans. Testing and implementing these procedures.
Environment: SQL Server 2000/2005/2008, Windows Server 2003(x64), Windows Cluster Server, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, HP Over View.