Detail-oriented System and Database Administration including designs, develops and maintains highly scalable, secure and reliable databases. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Having 9+ years of professional IT experience in System and Database Administration and Data Engineering – Teradata and BigQuery DBA.
Having good knowledge on Data warehousing concepts, and familiar with GCP cloud architecture -BigQuery, Dataproc, Cloud Composer, Compute Engine, Storage.Logs Explorer,Monitor.
Expertise on handling the Slots and reservation-based project requirement inside organization. Co-ordinating with Google team for P1 and P2 issues via Cases in the GCP console.
Monitoring the GCP BigQuery query performance in looker, bqviz and troubleshooting the errors.
Also performed migration activities as a part of Teradata to BigQuery Migration. Also having brief knowledge on Hadoop and MPP architecture.
Hands on experience in performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
Good Knowledge on CI/CD pipelines and using Github
Sound Knowledge on Change management, Problem management and high priority incident handling via ticketing tool like Service now, Jira and maintaining the same on Confluence.
Perform Teradata DBA activities like creation of Users, Databases, Roles, and Profiles
Perform space monitor regularly on daily bases and manage the space to avoid live failures
Monitor and control production boxes by performing various activities like Locks checks, Query monitoring using Viewpoint
Perform Data copy from production to dev & test boxes for testing and development purpose using
TARA
To work on access related issues raised by development, testing and Business users
Perform housekeeping for space management activities
Perform SQL query performance and tune as in required to reduce the resource consumption
Perform query optimization and assist developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of queries
Worked on production incident by analyzing the issue, root cause and solution on daily basis
Worked on production call during the duration on onshore by 24
7 production support for batches
Having good knowledge about the production batches and can able to solve production Incidents
Develop ARC scripts to perform backup and restore operations (Archive, Restore & Copy) of all the
Teradata database objects.
Walmart Inc
11.2020 - Current
Is an American multinational retail corporation that operates a chain of hypermarkets,
discount department stores, and grocery stores from the United States, headquartered in Bentonville
Arkansas
Description :
Day to day DBA activities like managing the databases, users, roles, profiles & access management in
both PROD & DEV environments in both Teradata and BigQuery including 24
7 DBA Support
Resolving performance issues like environment slowness, long running queries, Skewness etc
Hands on experience in performance tuning, including collecting statistics, analyzing explains &
determining which tables needed statistics
Workload Management, slot allocations and setting reservation as per the business requirements &
recommendations
Having good Knowledge in viewpoint setups and monitor production the systems end to end through
different viewpoint portlets (Query Monitor, System Health, Workload Monitor, Todays Statics, Space
Usage, Metrics Analysis, and other use full portlets)
Space allocations, movement and clean up
User, Role, Profile, Database objects creation and Administration
Restricting the User Access by Granting and Revoking Privileges to/from users
Preparation of Monthly DBA Report and Roadmaps
Excellent inter-personal and communication skills in collaborative mode with proficiency in grasping
new technical concepts quickly and utilize the same in a productive manner
Worked on ticketing tools like JIRA and Service Now on Severity and Priority basis
Worked on Tableau dashboard to generate various system and query metrics
(CPU/IO/AppId/Growth trend) subscriptions and presented to the customer which provide them a
better forecast on the business.
Database Administrator
Air Canada
05.2020 - 11.2020
Created and updated database designs and data models.
Created and implemented database designs and data models.
Designed and developed analytical data structures.
Modified databases to meet needs and goals determined during planning process.