Sr. Database Administrator

4 weeks ago

Tigard, United States CorSource Full time

Role Overview:


*Must be located in the Portland, OR Metro region*

As part of their agile development team, our client is seeking a self-motivated Senior Database Administrator who excels at creative problem solving, possesses effective communication skills, and thrives on collaboration with team members. Your primary responsibility will be to support and manage the production enterprise-wide databases. You will be handling the installation, configuration and upgrade of database server software and related products.


You will be entrusted to maintain backup and recovery plans, handle database security, and perform capacity planning. This person will also help build and maintain different ETL tools and packages to support our different company data flow/models. A motivated team player with a strong background in database administration, both in production and development support is required.


Role Responsibilities

  • Manage high volume databases within clustered environments and spanning across many companies
  • Knowledge of database security management practices, including access controls, and encryption
  • Diagnosis long running applications on the database level and perform corrective action with the use of both SQL Server native and third party performance tools
  • Create Heterogeneous replication strategies using native SQL Server replication, ETL, and cloud tools
  • Develop custom code, reports, and other data related task
  • Testing and Installation of new software
  • Create stored procedures, triggers and user defined functions and simple to complex DTS/SSIS packages in support of our data strategy goals and dev teams (data development/engineering work)
  • Create Entity Relationship Diagrams for developers and management staff
  • Import & export data to and from SQL server using ETL tools as well as native SQL and flat files (Excel)
  • Performance tune databases in development, test & production environments
  • Plan & migrate onprem SQL environments to the cloud (Azure
  • Participate in the resolution of complex design and implementation issues across projects

Experience

  • 5+ years of direct experience as a Database Administrator
  • 3+ years experience in utilizing SSMS, SSRS, SSIS
  • SQL Server Reporting Service (SSRS)
  • Reporting knowledge such as PowerBI, Domo, or Tableau
  • Understanding of how to administer SQL servers within Azure & managing Azure data factory
  • Strong desire to keep data integrity within the different systems and perform necessary backup/restores
  • Experience with .Net, C# and other structured languages
  • Deep knowledge of underlying network and protocols
  • Must have strong communication skills
  • Expert level understanding of current marketplace standards, technologies / trends and apply knowledge to user experience solutions
  • Highly motivated independent thinker
  • Ability to work closely with other teams and share best practices
  • Knowledge of SQL for database management and T-SQL for Microsoft SQL Server

Preferred Skills

  • Demonstrates proficiency with physical and logical database design
  • Can write and understand technical and functional design requirements
  • Basic understanding of machine learning models, algorithms, and data processing techniques. Knowledge of how to apply AI/ML, aid in predictive analytics, automation, & optimizing database operations
  • Ability to integrate AI/ML models into database environments to enhance capabilities such as predictive maintenance, anomaly detection in data, and automation of routine tasks
  • Understanding of other database technologies such as MongoDB, Snowflake, Cassandra, etc.

Who Are We????

CorSource is a technology consulting firm dedicated to turning innovation into a competitive advantage. Our solutions incorporate strategic consultants, subject matter experts, and agile project teams to harness the power of both people and technology. Since 1994, our clients have counted on us for the expertise to develop and implement technology-based solutions. At CorSource, we are driven by a strong set of values, a proven methodology, and a trusted community built on diversity and rewarding relationships. We are all about cultivating long-term connections with the people who work with us and our clients.

  • Sr. Database Administrator

    4 weeks ago

    Tigard, United States CorSource Full time

    Role Overview:*Must be located in the Portland, OR Metro region* As part of their agile development team, our client is seeking a self-motivated Senior Database Administrator who excels at creative problem solving, possesses effective communication skills, and thrives on collaboration with team members. Your primary responsibility will be to support and...

  • Systems Administrator

    3 weeks ago

    Tigard, United States IT Motives Full time

    ONLY CANIDATES CURRENTLY LIVING IN THE PORTLAND METRO AREA WILL BE CONSIDERED FOR THE ROLE AT THIS TIME.Our client is an industry leader in IT consulting and security. They are looking for an outstanding Systems Administrator as a part of the IT Operations team focused on maintaining networks and infrastructure for managed services accounts. The company is...

  • Systems Administrator

    2 weeks ago

    Tigard, United States IT Motives Full time

    ONLY CANIDATES CURRENTLY LIVING IN THE PORTLAND METRO AREA WILL BE CONSIDERED FOR THE ROLE AT THIS TIME.Our client is an industry leader in IT consulting and security. They are looking for an outstanding Systems Administrator as a part of the IT Operations team focused on maintaining networks and infrastructure for managed services accounts. The company is...

  • Systems Administrator

    1 week ago

    Tigard, United States IT Motives Full time

    ONLY CANIDATES CURRENTLY LIVING IN THE PORTLAND METRO AREA WILL BE CONSIDERED FOR THE ROLE AT THIS TIME.Our client is an industry leader in IT consulting and security. They are looking for an outstanding Systems Administrator as a part of the IT Operations team focused on maintaining networks and infrastructure for managed services accounts. The company is...

  • Systems Administrator

    1 week ago

    Tigard, United States IT Motives Full time

    ONLY CANIDATES CURRENTLY LIVING IN THE PORTLAND METRO AREA WILL BE CONSIDERED FOR THE ROLE AT THIS TIME.Our client is an industry leader in IT consulting and security. They are looking for an outstanding Systems Administrator as a part of the IT Operations team focused on maintaining networks and infrastructure for managed services accounts. The company is...

  • Revenue Specialist

    3 weeks ago

    Tigard, United States Quanta Services Inc Full time

    About Us Potelco, Inc., a subsidiary of Quanta Services, Inc. (NYSE: PWR), was founded in 1965. We specialize in engineering, procurement, and construction (EPC) services, which include designing, estimating, material acquisition, project management, construction, emergency power restoration, system maintenance, and similar services. Our expertise is in...

  • Revenue Specialist

    1 week ago

    Tigard, United States Quanta Services Inc Full time

    About Us Potelco, Inc., a subsidiary of Quanta Services, Inc. (NYSE: PWR), was founded in 1965. We specialize in engineering, procurement, and construction (EPC) services, which include designing, estimating, material acquisition, project management, construction, emergency power restoration, system maintenance, and similar services. Our expertise is in...

  • Revenue Specialist

    3 weeks ago

    Tigard, United States Quanta Services Full time

    Potelco, Inc., a subsidiary of Quanta Services, Inc. (NYSE: PWR), was founded in 1965. We specialize in engineering, procurement, and construction (EPC) services, which include designing, estimating, material acquisition, project management, construction, emergency power restoration, system maintenance, and similar services. Our expertise is in power,...

  • Revenue Specialist

    1 week ago

    Tigard, United States Quanta Services Full time

    Potelco, Inc., a subsidiary of Quanta Services, Inc. (NYSE: PWR), was founded in 1965. We specialize in engineering, procurement, and construction (EPC) services, which include designing, estimating, material acquisition, project management, construction, emergency power restoration, system maintenance, and similar services. Our expertise is in power,...

  • Office Specialist 2

    1 week ago

    Tigard, United States State of Oregon Full time

    Job Description: Position Title:                      Office Specialist 2 (Bilingual Spanish)Initial Posting Date:            June 4, 2024        Application Deadline:         June 18, 2024Salary Range:                      $3,218 - $4,338 per...

  • Office Specialist 2

    1 week ago

    Tigard, United States State of Oregon Full time

    Job Description: Position Title:                      Office Specialist 2 (Bilingual Spanish)Initial Posting Date:            June 4, 2024        Application Deadline:         June 18, 2024Salary Range:                      $3,218 - $4,338 per...

  • Collections Specialist

    1 week ago

    Tigard, OR, United States Kaiser Permanente Full time

    Job Summary: Revenue Management Recovery team will design and deploy strategic delivery arm of revenue cycle that will deliver the changes, Team assembled to perform root cause analysis and remediation to investigate issues in accounts and identify solutions and collaborate with regions and KPHC for ongoing corrections Revenue Management recovery processes,...

  • Collections Specialist

    2 days ago

    Tigard, OR, United States Kaiser Permanente Full time

    Job Summary: Revenue Management Recovery team will design and deploy strategic delivery arm of revenue cycle that will deliver the changes, Team assembled to perform root cause analysis and remediation to investigate issues in accounts and identify solutions and collaborate with regions and KPHC for ongoing corrections Revenue Management recovery processes,...

  • Revenue Management Recovery Specialist

    1 week ago

    Tigard, OR, United States Kaiser Permanente Full time

    Job Summary: Revenue Management Recovery team will design and deploy strategic delivery arm of revenue cycle that will deliver the changes, Team assembled to perform root cause analysis and remediation to investigate issues in accounts and identify solutions and collaborate with regions and KPHC for ongoing corrections Revenue Management recovery processes,...

  • Revenue Management Recovery Specialist

    2 days ago

    Tigard, OR, United States Kaiser Permanente Full time

    Job Summary: Revenue Management Recovery team will design and deploy strategic delivery arm of revenue cycle that will deliver the changes, Team assembled to perform root cause analysis and remediation to investigate issues in accounts and identify solutions and collaborate with regions and KPHC for ongoing corrections Revenue Management recovery processes,...