Vacancy caducado!
- Manage multiple databases across disparate platforms including Microsoft SQL Servers and data warehouse systems.
- Proactive maintenance of all database instances (upgrades, patching, integrity check, security control), during normal business hours, and/or, off hours to reduce impact to business operations.
- Responsible for the overall performance, tuning and backup/recovery of all MS SQL instances.
- Proficiency in stored procedures, triggers, views, replication, and performance tuning.
- Implement, maintain and execute data scrubbing/obfuscation scripts for testing, staging and production environment.
- Implement data retention policies for operational, as well as sensitive data store.
- Evaluate, recommend, and implement database management and monitoring tools.
- Troubleshoot and maintain various scheduled jobs and SSIS Packages for maintenance, monitoring, and specific business needs.
- Design and implement redundant systems for high availability, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets for compliance and audit.
- Managing Users and Roles for both business user and service account to ensure proper access control.
- Plan, document, implement and manage custom database structure including data import and validation.
- Consistently perform data steward functions to safe guard data integrity.
- Appropriately document issues and resolutions in IT ticketing system.
- Technical expertise in database and schema design patterns.
- Partner with Director of Information Technology, Application Developers, Data Center Analyst and various other departments to review implementation requests, provide feedback, deploy and maintain these requests.
- Conduct code review, data/schema comparison, and query optimization by examining execution plan and profiling.
- Responsible for SSRS report planning, development, implementation and maintenance.
- Experience with DB change and deployment strategies.
- Experience with data modeling.
- Experience working with SSIS Packages, ETL, ELT.
- Experience interface with third party integration (with, or without API).
- Experience with data warehousing.
- Experience with or knowledge of Cloud based solutions and connectivity with on premise systems and replication such as AWS and/or Azure.
- Experience and/or general knowledge with following compliance and audit requirements (CCPA/GDPR, PII, PCI, SOX, HIPAA, et al).
- Ability to follow computer schedules, is detail-oriented, and accepts ownership of a task until completed.
- Ability to reason and anticipate the outcome of repeated processes to assist in daily processing.
- Is organized, thorough, and has a respect for quality control.
- Has strong time management skills and ability to juggle priorities.
- Ability to be autonomous with minimal supervision.
- Ability to maintain composure and learn quickly on the fly.
- Maintains strong verbal and written communication.
- Working knowledge of computer hardware, software, and peripheral equipment.
- Working knowledge of the concepts of data communications.
- Working knowledge of Microsoft Windows and Office.
- Advanced knowledge of SQL
- Advanced working knowledge of MS SQL Server with specific emphasis on database/table management, index tuning, and performance monitoring.
Vacancy caducado!