06/16/2023 updated
JD
100 % available
Teradata Database Administrator, Hadoop SA
United Kingdom
Worldwide
Unity 3dAcceptance TestingAgile MethodologyData AnalysisSoftware ApplicationsAtlassian JiraCA Workload Automation AeMicrosoft AzureBig DataCloud ComputingCluster AnalysisDatabasesExtract Transform Load (ETL)Data StructuresData Warehousing
Acceptance Testing, Agile methodologies, Hadoop, Hive, Big Data, Bitbucket, Autosys, Cloud, Cloudera, Cloudera Manager, Clustering, Exploratory Data Analysis, Data Analytics, Data analysis, data structures, Data Warehousing, data warehouse, Enterprise Data Warehouse, Database Design, database, Databases, Endevor, Data movement, XP, File Systems, HDFS, Maximo, Access management, Computer Services, ticketing system, Jira, JDK, Machine Learning, Mainframe, Matplotlib, Azure, MS Excel, Excel, Sharepoint, Windows NT, MongoDB, Netbackup, servers, NoSQL databases, NumPy, OLAP, open source, operational systems, Pandas, Performance monitoring, Performance tuning, Plotly, portlet, Power BI, Python Programming, Python, Database Query Language, RHEL, RDBMS, SQL, scikit-learn, Scrum Teams, Computer Applications, Hypothesis Testing, SDLC, Tableau, Teradata, Unity
Experience
Professional experience0 - 5 years
Freelancer since2023
Languages
EnglishGood
Project history
Barclays Bank PLC is one of the largest banks in UK. It has its operations distributed across
several locations. Data from various source systems is fed into the EDW (Enterprise Data Warehouse).
Bank has a dedicated infrastructure wing for catering the needs of this EDW known as DWS (Data
Warehousing Services). Data Warehousing Services manages the platform infrastructure hosting data
from the Group's operational systems providing the capability for users or operational systems to
query and extract this information as required.
Responsibilities:
* Barclays implements ticketing system (Service center) for all Order/Changes/Incidents which are
assigned/picked up by the DBA's to resolve. Involved in resolving all kinds of tickets that are
assigned, with in their respective SLA periods.
* Involved in DBA activities such as
* Creating Users, Databases and other objects,
* Creating/maintaining Roles and Profiles and assigning them to users,
* Space management,
* Access management.
* Administering Teradata database (5 different MPP Systems) using Teradata Manager, Teradata
Administrator and other Teradata internal tools.
* Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD
Alert and other Barclay's specific internal monitoring/alerting tools.
* Data movement across different Teradata servers to support development team..
* Also involved in implementing new projects (applications) on pre-production machine and advise
the users in case of discrepancies, so that they can be avoided while implementing on production
box. This implementation needs bunch of tasks to be executed such as creation of new data
databases, Views databases, Users, tables, view and other objects as per requirement of the
project. This is termed as OAT (Operational Acceptance Testing).
* Investigating the occurred discrepancies, through DBQL and communicating to the end users.
several locations. Data from various source systems is fed into the EDW (Enterprise Data Warehouse).
Bank has a dedicated infrastructure wing for catering the needs of this EDW known as DWS (Data
Warehousing Services). Data Warehousing Services manages the platform infrastructure hosting data
from the Group's operational systems providing the capability for users or operational systems to
query and extract this information as required.
Responsibilities:
* Barclays implements ticketing system (Service center) for all Order/Changes/Incidents which are
assigned/picked up by the DBA's to resolve. Involved in resolving all kinds of tickets that are
assigned, with in their respective SLA periods.
* Involved in DBA activities such as
* Creating Users, Databases and other objects,
* Creating/maintaining Roles and Profiles and assigning them to users,
* Space management,
* Access management.
* Administering Teradata database (5 different MPP Systems) using Teradata Manager, Teradata
Administrator and other Teradata internal tools.
* Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD
Alert and other Barclay's specific internal monitoring/alerting tools.
* Data movement across different Teradata servers to support development team..
* Also involved in implementing new projects (applications) on pre-production machine and advise
the users in case of discrepancies, so that they can be avoided while implementing on production
box. This implementation needs bunch of tasks to be executed such as creation of new data
databases, Views databases, Users, tables, view and other objects as per requirement of the
project. This is termed as OAT (Operational Acceptance Testing).
* Investigating the occurred discrepancies, through DBQL and communicating to the end users.