| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data Architect ProfileEMAIL AVAILABLE PHONE NUMBER AVAILABLE(h) PHONE NUMBER AVAILABLE (m)LINKEDIN LINK AVAILABLE Colorado Springs, USAccomplished Database Administrator and Developer with extensive experience managing product development and testing projects as well as optimizing complex database environments and data quality/consistency. Known as Subject Matter Expert in query tuning and writing T-SQL code along with stored procedures and database objects. In-depth knowledge of replication, log shipping, data migration, and data mirroring. Instrumental in overseeing architecture, design, and integration of data solutions. Well-versed in ensuring robust management of data lifecycle by establishing enterprise standards and frameworks.Technical ProficienciesOperating Systems:Windows 2016, UNIX, AIX, Solaris 2.x/7, Redhat, LINUX, z/OS, Ubuntu TLS, CentOSDatabase Management:MSSQL 2016/2017/2019, MySQL 5.7/8.0.6, PostgreSQL, Oracle 19c, DB2 UDB, OLTP, OLAP, Data Warehousing, PostgreSQL (Community Edition)Software & Tools:MS SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Profiler, VISIO, Enterprise Manager, SSMS, i3-Precise, Idera Admin toolset, SolarWinds Database Performance Analyzer (DPA), Dynatrace, Tableau, Power BI, Korn Shell, Bash Shell, Docker, dask, ArcGIS, QGIS, and PowerShellProgramming Languages:Python, Anaconda, T-SQL, C#, Node.JSCore Competencies:Database Management & Architecture, Project Lifecycle Management, Product Development & Testing, Solution Development, Performance Tuning, Application Performance Optimization, Data Modeling & Migration, Continuous Improvement, Clustering & Data Warehousing Concepts, Oracle/MySQL/SQL Server Installation/Configuration & Performance Tuning,Career ExperienceSr. Database Administrator Bluehalo LLC, Colorado Springs, CO 07/2022 04/2023Oversaw replication, performance tuning, and monitoring of MariaDB and PostgreSQL (Community Edition) databases. Maintained Galera cluster using MariaDB. Utilized Percona Monitoring for monitoring the uptime of databases.Key Accomplishment:Gained valuable knowledge of setting up of replication and Perocna Monitoring and Management (PMM) tool.Database Architect Contract, Charter Communications, Greenwood Village, CO 3/2022 05/2022Oversee planning and automation of programs using Anaconda, dask, Python, AWS S3, AWS Lambda, ArcGIS, QGIS, PostgreSQL 14(Community Edition), and AWS in support of 5G trial executed by the company in Charlotte and LA Counties. Design and deliver frequencies to facilitate the company as mandated by FCC through calculation of interference with Navy.Key Accomplishment:Gained valuable knowledge of database architect, AWS, Azure, and cloud expertise along with the migration of databases through lift and shift, and performance tuning.Sr. Database Administrator, LexisNexis Risk Solutions, Chandler, AZ 12/2021 3/2022Offered support for AWS DynamoDB databases, while maintaining AWS Aurora MySQL/PostgreSQL and Redshift databases using AWS CLI. Created ETL code via Docker and connected to AWS Aurora MySQL and AWS Redshift through Python and PowerShell.Key Accomplishment:Directed upgrade and migration of AWS Aurora MySQL 5.7 to version 8, while updating parameter values and developing Support Tickets with AWS support.Database Consultant Contract, Vantage Data Center, Cherry Creek Village, CO 10/2021 12/2021Led upgrade of Percona Management and Monitoring (PMM) software on Ubuntu and Centos machines. Enabled monitoring of IoT devices in hyperscale data centers across North America and Europe by facilitating MySQL, PostgreSQL(Community Edition), and MongoDB. Coordinated deployment of code in CI/CD pipeline by supporting SQL Server database in Azure environment using Azure DevOps.Key Accomplishment:Concluded upgrade of Percona Management and Monitoring tool on Ubuntu-TLS and CentOS machines.Database Developer Contract, AAA Colorado, Denver, CO 6/2021 9/2021Steered migration of on-premises SQL Server 2012 data warehouses to SQL Server 2016 and Server 2017. Collaborated with team members to carry out assigned tasks as per project scope and business requirements. Upgraded MySQL 5.6 to MySQL 8.0.6.Key Accomplishments:Initiated troubleshooting of SSIS packages and SSRS reports.Ensured robust management of Capgemini DBAs after successful knowledge transfer.Database Consultant Contract, USA Cycling, Colorado Springs, CO 11/2020 2/2021Upgraded MySQL 5.7 version to 8.0 databases. Supported legacy application hosted in AWS RDS. Formulated Entity Relationship Diagram through MySQL Workbench, and devised ETL jobs via Docker and PHP.Key Accomplishments:Enhanced functioning of applications running on MariaDB and Docker.Expedited data migration by collaborating with developers and ScrumMaster, while coordinating two-week scrum meetings and updating JIRA tickets.Career NoteSenior Database Administrator PGI/ Colorado Springs, CO, 9/2019 11/2019; supported development of UCaaS model, migrated on-premises databases to AWS, installed Windows Failover Cluster (FCI), upgraded SQL Server 2008 R2 to 2014 on AWS EC2 instances, and led migration of new applications to Azure Cloud. Delivered programs using C# and Node.JS for new deployments across Azure environment.Database Developer Contract DISH Network/ Englewood, CO, 6/2019 8/2019; designed stored procedures along with function for work order fulfillment group. Utilized C# and T-SQL to write stored procedures, triggers, and functions.Performed as Senior Database Administrator on Contract basis from 1/2019 to 2/2019 at Whiting Petroleum Co. in Denver, CO.Database Developer Contract CenturyLink/ Broomfield, CO, 9/2017 9/2018; introduced SSIS packages via Visual Studio 2012 and 2015, while creating SSRS reports and migrating MS Access 2016 Otter database to SQL Server 2016.Database Administrator Summit Utilities, Inc., Littleton, CO, 1/2015 7/2017; led cutover from UMS ERP to Cayenta software; resolved performance issues with SQL Server databases using SolarWinds Database Performance Analyzer and Dynatrace; accelerated upgrade of SQL Server 2008 to R2 and 20123. Enabled GIS database tuning at server/database level based through performance tuning of queries. Executed comprehensive database disaster recovery testing through Abtech and AppAssure tools, while migrating on-premises SQL Server databases to AWS and configuring replication for GIS. Headed architecture of natural gas modeling system using DNVGL and Oracle 11g software.Career NoteDatabase Administrator Contract, City and County of Denver, Denver, CO, 3/2014 1/2015Database Administrator Contract, T Systems, Scottsdale, AZ, 6/2013 8/2013System Administrator, Air Methods, Englewood, CO, 6/2012 11/2012SQL Database Administrator Contract, MI-JACK/ Chicago, IL, Contract, 11/2013 12/2013Database Administrator Contract, First Data, Greenwood Village, CO, 2/2011 2/2012Database Advisor, FedEx, Milwaukee, WI, 1/2011 2/2011Database Administrator, OnTargetJobs Inc., Englewood, CO, 5/2010 11/2010Database Administrator, Wells Fargo, San Leandro, CA, 11/2009 3/2010EducationMSCS in Software Engineering (Completed 16 Credit Hours), Colorado Technical UniversityBachelor of Science (B.Sc.), Civil Engineering, National Institute of Technology, Patna, IndiaMBA in Leadership (have completed Nine Credit Hours), Adams State UniversityProfessional DevelopmentCertified Scrum Master, Scrum AllianceSecurity+ certified, CompTIAITIL v3 Foundation Certificate, AxelosMastering the Art of Negotiation, UC Berkley ExtensionManaging the Organization Certificate, University of Illinois at Urbana-ChampaignIntroduction to Business Analytics Certificate, University of Illinois at Urbana-Champaign |
