Vivek Chandra
Data Architect Profile
ad0q70@r.postjobfree.com • 719-***-****(h) 719-***-**** (m)
www.linkedin.com/in/vivekchandraco/ • Colorado Springs, US
Accomplished 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 Proficiencies
Operating Systems:
Windows 2016, UNIX, AIX, Solaris 2.x/7, Redhat, LINUX, z/OS, Ubuntu TLS, CentOS
Database 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 PowerShell
Programming Languages:
Python, Anaconda, T-SQL, C#, Node.JS
Core 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 Experience
Sr. Database Administrator– Bluehalo LLC, Colorado Springs, CO 07/2022 – 04/2023
Oversaw 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/2022
Oversee 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/2022
Offered 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/2021
Led 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/2021
Steered 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/2021
Upgraded 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 Note
Senior 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 Note
Database Administrator – Contract, City and County of Denver, Denver, CO, 3/2014 – 1/2015
Database Administrator – Contract, T Systems, Scottsdale, AZ, 6/2013 – 8/2013
System Administrator, Air Methods, Englewood, CO, 6/2012 – 11/2012
SQL Database Administrator – Contract, MI-JACK/ Chicago, IL, Contract, 11/2013 – 12/2013
Database Administrator – Contract, First Data, Greenwood Village, CO, 2/2011 – 2/2012
Database Advisor, FedEx, Milwaukee, WI, 1/2011 – 2/2011
Database Administrator, OnTargetJobs Inc., Englewood, CO, 5/2010 – 11/2010
Database Administrator, Wells Fargo, San Leandro, CA, 11/2009 – 3/2010
Education
MSCS in Software Engineering (Completed 16 Credit Hours), Colorado Technical University
Bachelor of Science (B.Sc.), Civil Engineering, National Institute of Technology, Patna, India
MBA in Leadership (have completed Nine Credit Hours), Adams State University
Professional Development
Certified Scrum Master, Scrum Alliance
Security+ certified, CompTIA
ITIL v3 Foundation Certificate, Axelos
Mastering the Art of Negotiation, UC Berkley Extension
Managing the Organization Certificate, University of Illinois at Urbana-Champaign
Introduction to Business Analytics Certificate, University of Illinois at Urbana-Champaign