Data Administrator role managing T-SQL scripts and database architecture for client companies. Developing, monitoring, and tuning database systems to improve performance.
Responsibilities
Create T-SQL scripts for report extraction and routine automation. Knowledge of relational modeling and extract, transform and load (ETL) processes;
Support developers with access, user management, diagrams, programmable objects and bulk data manipulation for testing and acceptance;
Define tables, indexes, views, constraints, triggers, stored procedures, storage parameters or tablespaces and other database-specific constructs required to store, retrieve and delete persistent objects;
Develop and maintain the corporate data model (CDM), data integration architecture, data taxonomy, and data and metadata standards;
Define and maintain Golden Records, hierarchies, master and reference data; understand, develop and maintain metadata;
Design, implement and maintain solutions that meet the company’s data needs. Includes data-focused activities within the system development lifecycle, such as data modeling, data requirements analysis and design, deployment and database maintenance;
Monitor and tune database performance: perform proactive (preventive) and reactive (post-incident) monitoring. This involves managing user response time performance from a variety of root causes (SQL coding issues, problematic commands, poor database design, missing proper indexes, outdated statistics used by the query optimizer, etc.);
Administration and management of local and remote databases;
Automate routines using Shell Script;
Configure environments to optimize performance;
Build database architectures for high availability (clustering) based on technology best practices;
Build architectures for bulk data transfer;
Define and execute data loading and extraction routines;
Develop and maintain procedures for querying, capturing, updating and storing data;
Requirements
Experience in:
Data manipulation (DML) and definition (DDL) activities: defining tables, indexes, views, constraints, triggers, stored procedures, storage parameters or tablespaces and other database-specific constructs required to store, retrieve and delete persistent objects;
Monitoring and tuning database performance: proactive (preventive) and reactive (post-incident) monitoring. Involves managing user response time performance resulting from various root causes (SQL coding issues, problematic commands, poor database design, missing proper indexes, outdated statistics used by the query optimizer, etc.);
Configuration, implementation, monitoring, tuning and data auditing;
Troubleshooting and incident resolution, including root cause analysis for database-related issues.
Storage and SAN Infrastructure Administrator managing physical, virtual, and cloud - based data storage for Kyndryl. Ensuring security, availability, and performance while collaborating with IT teams and vendors.
Backup Infrastructure Administrator managing physical, virtual, and cloud - based backup infrastructures. Ensuring data protection, recoverability, and compliance in distributed environments while collaborating with IT teams.
IT & Web Administrator ensuring seamless operation of systems for OverTake, a sim racing community. Involves infrastructure management, cybersecurity, and compliance responsibilities.
IT - Systemadministrator ensuring smooth processing of user requests and managing IT equipment installation. Central point for internal staff and incident resolution.
Lead a team of IT technicians in Munich for a technology partner company. Provide support and develop IT infrastructure while overseeing operations and project leads.
Functioneel Beheerder in een taal - en inburgeringsschool verantwoordelijk voor kwaliteitsborging en rapportages. Werken in een hybride omgeving als onderdeel van een team dat scholing verzorgt.
Customer Service Representative maintaining insurance accounts and providing service through direct communication. Collaborating with the Region Executive Officer to manage these accounts at Livestock Marketing Insurance Agency in Overland Park, Kansas.
IT Systemadministrator assisting in the development of Microsoft - based IT infrastructure. Involved in support tickets, error diagnostics, and collaborative IT projects at bauXpert GmbH.
IT System Administrator responsible for maintaining customer IT infrastructures and handling support requests. Working within a managed services team and implementing Microsoft systems and virtualization solutions.
Assistente de Administração de Pessoal at St. Marche overseeing admission processes and ensuring compliance with internal routines in a hybrid work environment.