Published date Posted on Indeed on Aug 09, 2022 (59 d ago)
Overview:
The Senior Database Architect must have experience creating work breakdown structures and development of program schedules and assigning software development team personnel to tasks. Must have experience in the tracking resources and expenditures and in ensuring program success!
Responsibilities:
  • The candidate would work with a great team of IT professionals to complete multiple complex projects where innovation is encouraged to efficiently produce customer deliverables
  • This is a challenging position, there are both complex database designs and UI transformational opportunities
  • There are simple to complex ETLs with opportunity to collaborate with other teams to manage or create new large dataset extracts
  • Create/revise and maintain a databases with terabytes of data used for large sql/ssms queries used to compile large, complex reports
  • Manage customer relational database tables and architecture
  • Create and manage database views for SSMS users, Kendo UI and Power BI reporting
  • Create, design, test iterative project feature/functionality releases that include UI and API integration
  • Manage operation and maintenance of databases with replication and backups across 3 environments, development, staging and production
  • Assesses risks and benefits for optimal database design, provide recommendations and implement plans
  • Manage all database schema updates and optimizations
  • Ensure database connectivity across different reporting tools
  • Conduct/participate in customer facing meetings for requirements gathering, reviewing feasibility and options in non-technical terms
Qualifications:
  • Microsoft SQL Server, Integration Services (SSIS/ETL-extract, transform, load), Management Studio(SSMS), Visual Studio
  • Architect complex custom database designs, scripts, stored procedures and API integration
  • Build ETLs from multiple types of data sources requiring multiple techniques such as SSIS, C# & PowerShell to normalize data extracts containing millions of records
  • Manage SQL server instances across multiple servers including optimization and process monitoring
  • Operating Systems: Microsoft Windows Server 2012, 2016, 2019
  • Familiarity with Oracle, Power BI, Web based development processes

Education:

  • Master’s degree in Computer Science, Information Systems, Mathematics, Business or similar preferred and 5 years of relevant experience. Or Bachelor’s degree in Computer Science, Information Systems, Mathematics, Business or similar preferred and 10 years of relevant experience
Clearance:
  • The ability to pass a Tier 2/Modest Background Investigation
Location:
  • Remote, USA

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

American Electric Power American Electric Power |
17 d ago

Job Description:Information TechnologyThis is for AEP (American Electric Power) Commercial Operations. The ideal candidate will have will have experience in all phases of software development: gathering user requirements, making architecture decisions,.

Maharishi Foundation International Maharishi Foundation International... |
2 d ago

About UsMaharishi Foundation International (MFI) is a US-registered non-profit that supports the development of new technologies and outreach opportunities for the worldwide Transcendental Meditation® (TM®) organisations. Over the past 60 years, more.

American Electric Power American Electric Power |
10 d ago

Job Description:This position is Remote. Candidates will be considered based on their qualifications and the candidate's ability to work from an approved work location. Although the location is flexible, AEP does not have a presence in all states and.

ResponsibilitiesProvide clinical data management support to clinical development franchise(s) and related Clinical Operations team and/or study project, Safety, Clinical Management team and Biostatistics.Participate in the review of clinical research.

ABOUT THIS JOB:Data and Analytics Engineering - Platform team is critical to making our organization's data strategy successful. You will play a key role in architecting and engineering modern, adaptive, data-driven, and secure platforms and processes.