Vacancy expired!
- Work with business and application/solution teams to implement data strategies, build data flows, and manage relational data replication processes.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
- Create and maintain primary database storage structures; Allocate system storage and plan for future storage requirements.
- Performing intricate SQL Scripting, developing stored procedures, creating complex database SQL queries, and developing functions, views, etc.
- Create primary database objects (tables, views, indexes); modify the database structure, as needed.
- Monitor and optimize the database performance.
- Apply database updates and patches.
- Migrate databases to new hardware as required.
- Write PL/SQL stored procedures and triggers.
- Recommend new architectures, designs, and strategies for the future.
- Analyze performance and scalability of the database, providing input for architectural enhancements.
- Testing, implementing, maintaining, and controlling the organization’s databases across multiple platforms and technologies (e.g., physical, relational, and object-oriented) in an Azure cloud environment.
- Perform disciplined, auditable execution of established data warehouse ETL (extract/transform/load) programs and refresh procedures.
- Execute recurring manual data extractions, downloads, and pre-processing of data files.
- Contribute to the development of new methods, procedures, processes, or systems and understand the impact of these changes.
- Provide support and expertise in the investigation and resolution of performance-related issues for warehousing environments.
- Proactively monitor and remedy data quality failures in recurring ETL and refresh processes
- Provide support in installing & upgrading database software and resolving database software problems.
- Perform evaluations of potential tools & utilities.
- Automate database tasks via scripting or through the use of tools.
- Proactively configure, monitor, and review statistics for errors, capacity, and performance issues
- Tune and troubleshoot software & database performance issues.
- Other duties as assigned.
- Bachelor's Degree or higher (from an accredited University) in computer engineering or in a field related to computer engineering or computer science disciplines.
- 3+ years of technical experience in database architecture required.
- Prior experience in working with databases in data warehousing environments is required.
- Knowledge and experience in SQL environments, including experience building and managing Microsoft SQL environments; maintaining system security; and working with the development and data analytics team.
- Excellent interpersonal skills with the ability to engage at all levels of the organization.
- Demonstrate a professional and adaptable demeanor with internal and external clients, including administrators, physicians, peers, and support staff.
- Excellent verbal and written communication skills.
- The ability to multi-task, plan and prioritize a large volume of detail-oriented work in accordance with changing deadlines.
- The ability to work with minimum supervision, set priorities, and follow through to accomplish results.
- Ability to cope with stressful situations and maintain a calm and professional demeanor.
- Amazon AWS, GovCloud, Azure, or other virtualization technologies is a PLUS.
- ID: #48943378
- State: Maryland Woodlawn 21207 Woodlawn USA
- City: Woodlawn
- Salary: $80,000 - $100,000
- Job type: Permanent
- Showed: 2023-01-31
- Deadline: 2023-03-26
- Category: Software/QA/DBA/etc