Database Systems Administrator

2 days ago


Pasco, Washington, United States TNS Limited Full time
Database Administrator III Job Description

An exceptional team of professionals at TNS Limited collaborates daily to drive success, both professionally and personally. We invite you to be part of this excellence.

Job Summary

The Database Administrator III is responsible for supporting, maintaining, and developing TNS's databases, which support a wide range of TNS products. This role requires experience with multiple database technologies, including Oracle, MongoDB, MariaDB in Linux environments, and MS SQL Server. The ideal candidate is a self-motivated individual with excellent communication skills and the ability to work well in a collaborative environment.

Key Responsibilities

  • Provide daily database administration and support for databases primarily Oracle, MariaDB, MongoDB, and SQL Server databases.
  • Implement and support administrative tasks such as backup and recovery procedures, database utilities, and data replication technologies across development, test, and production environments.
  • Troubleshoot and provide technical support, involving effective communication with internal and external customers on SQL bugs, application issues, and identifying anomalies to implement corrective actions for all production and non-production environments in a timely manner.
  • Manage organizational data definitions and process flows to ensure consistency, security, and accuracy of transactional data.
  • Provide technical services to monitor and maintain environments running on organization's strategic platforms, including periodic software upgrades, vulnerability patching, and migration of databases.
  • Document operational or newly engineered solutions properly to educate and inform the IT Support staff at various levels.
  • Create and maintain Linux and SQL scripts to automate scheduled tasks, monitor, and database alerts.
  • Log, schedule, and track all changes using change management system tools.
  • Responsible for all corrections to the database infrastructure and for repairs to the system or database.
  • Provide 24x7 on-call support in rotation for production databases.

Requirements

  • Must have 6+ years of advanced database administration experience with large-scale Oracle, MySQL, SQL Server in multi-node clustered environments, including replication and security.
  • Working experience of database administration experience in MongoDB and MariaDB with development experience.
  • Working experience in database administration and data migration in cloud and AWS technologies with development experience preferred.
  • Working experience in Oracle RAC environment, preferably with Oracle Goldengate.
  • Must be strong with SQL Maintenance, Back-up, SQL Stored Procedures, High-Availability, Performance Tuning, and Future Architecture Design and Expansion.
  • Working knowledge of data modeling; database administration problems and requirements; and database analysis and design procedures, techniques, and implementation.
  • Experience with Database Warehousing, Decision Support, and OLTP.
  • Strong working experience in reviewing, writing, and debugging, tuning complex SQL stored procedures, functions, and triggers, etc.
  • Experience with advanced SQL Server network connectivity and protocols.
  • Strong working experience using various database Tools and SQL Performance Analyzer, etc.
  • Highly motivated with a commitment to quality service.
  • Strong knowledge of managing projects and excellent communication skills required.
  • For this role, we anticipate paying $101,000-$124,000 annually. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location. TNS offers a competitive benefit package including medical and dental coverage, life insurance, paid holidays and vacations, and a 401K plan with company match.
  • Must be a self-starter, able to prioritize and work well under pressure.
  • Ability to communicate orally and in writing clearly and straightforwardly.
  • Ability to handle multiple projects and tasks.

Qualifications

If you are passionate about technology and love personal growth and opportunity, come see what TNS is all about.

TNS is an equal opportunity employer. TNS evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.


  • CRM Administrator

    3 days ago


    Pasco, Washington, United States Center for Strategic and International Studies Full time

    Job Title: CRM AssociateAt the Center for Strategic and International Studies (CSIS), we are seeking a highly skilled CRM Associate to join our team. As a key member of our organization, you will play a critical role in administering our Customer Relationship Management (CRM) system, ensuring its effective use and maintenance.Key Responsibilities:Manage the...


  • Pasco, Washington, United States CHICKASAW NATION INDUSTRIES INC Full time

    Job SummaryThe Administrative Specialist plays a vital role in supporting the United States Agency for International Development's (USAID) Office of Civil Rights (OCR), Strategic Program Operations (SPO) Division. Based in the Washington, DC area, the Administrative Specialist serves as a key point of contact for Bureau staff in Washington and in the field,...


  • Pasco, Washington, United States NexThreat Full time

    Job Title: ICAMO Sr ICAM Operations AdministratorNexThreat is seeking a highly skilled ICAMO Sr ICAM Operations Administrator to lead the day-to-day operations of ICAM systems, ensuring they are functioning efficiently and securely across the organization.Key Responsibilities:Oversee regular maintenance activities, including software updates, patch...


  • Pasco, Washington, United States NexThreat Full time

    Job Title: ICAMO Sr ICAM Operations AdministratorNexThreat is seeking a highly skilled ICAMO Sr ICAM Operations Administrator to lead the day-to-day operations of ICAM systems, ensuring they are functioning efficiently and securely across the organization.Key Responsibilities:Oversee regular maintenance activities, including software updates, patch...


  • Pasco, Washington, United States Inova Health System Full time

    Job SummaryWe are seeking a highly organized and detail-oriented Administrative Support Specialist to join our team. The successful candidate will provide administrative support to the department leadership and other staff, ensuring the smooth operation of our office.Key ResponsibilitiesPerform data entry work using a personal computer and appropriate...


  • Pasco, Washington, United States Blue Collar Full time

    Join Our Award-Winning Team as a Project Administrator/Assistant Project ManagerWe're a top-tier federal contractor with 30+ years of experience keeping premium government buildings, commercial, and residential spaces running like a well-oiled machine. From HVAC to fire control systems, elevators to pest control, we've got it covered-and now, we want YOU to...

  • Application Analyst

    2 weeks ago


    Pasco, Washington, United States Pasco School District 1 Full time

    Pasco School District 1 Job OpportunityWe are seeking a highly skilled and experienced Application Analyst to join our Information Systems department. As a key member of our team, you will be responsible for designing, building, and implementing automation solutions using Laserfiche, our digital forms, workflow, and document management system.Key...


  • Pasco, Washington, United States Legends Casino Hotel Full time

    Job Summary:As a key member of the Legends Casino Hotel team, the Electrical Systems Specialist will be responsible for performing journey-level work on the casino's electrical systems, directing the work of junior electricians, and ensuring the safe and efficient operation of electrical equipment. This role requires a high level of technical expertise,...


  • Pasco, Washington, United States State of Washington Full time

    Job Title: Training and Information AnalystJoin the State of Washington Department of Corrections as a Training and Information Analyst, where you will play a crucial role in supporting the data and reporting functions of the Agency's Learning Management System, Learning Center.About the Role:This is a telework/hybrid position, allowing you to work from...


  • Pasco, Washington, United States State of Washington Full time

    Job Title: Human Resource Consultant 3Join the State of Washington's Department of Corrections as a Human Resource Consultant 3 in the Training and Development Unit. As a key member of our team, you will play a crucial role in supporting the development and implementation of training programs for our staff.About the Role:This is a unique opportunity to work...


  • Pasco, Washington, United States First Tek Full time

    Job SummaryWe are seeking a highly skilled Business Systems Analyst 2 to join our team at First Tek. As a key member of our IT department, you will be responsible for analyzing and improving our business systems and processes.Key ResponsibilitiesAssist the Transmission business line as Microsoft Project and SharePoint specialist.Serve as a point of contact...

  • Program Coordinator

    2 days ago


    Pasco, Washington, United States Center for Strategic and International Studies Full time

    Job Title: Program CoordinatorThe Center for Strategic and International Studies (CSIS) is seeking a highly organized and detail-oriented Program Coordinator to support the successful administration and execution of educational and professional development programming.Key Responsibilities:Assist with budget management, including tracking finances for various...


  • Pasco, Washington, United States First Tek Full time

    Job DescriptionJob Title: Business Systems Analyst 3Job Summary:First Tek is seeking a highly skilled Business Systems Analyst 3 to join our team. As a key member of our organization, you will be responsible for ensuring the reliability and security of our systems and processes.Responsibilities:Provide monitoring, review, analysis, and support for the...

  • GIS Analyst

    4 weeks ago


    Pasco, Washington, United States State of Washington Full time

    Job Title: GIS AnalystWe are seeking a highly skilled GIS Analyst to join our team at the State of Washington. As a GIS Analyst, you will play a critical role in developing and maintaining geographic information systems (GIS) databases, processing and tools to support the needs of our program.Key Responsibilities:Develop viewable, editable, and...


  • Pasco, Washington, United States Diverse Lynx Full time

    About the RoleWe are seeking a highly skilled Essbase Hyperion Planning Expert to join our team at Diverse Lynx LLC. As a key member of our organization, you will be responsible for designing, developing, and maintaining complex planning models and Essbase databases.Key ResponsibilitiesPlanning Model Development: Develop and implement Hyperion Essbase...


  • Pasco, Washington, United States Epiq Full time

    Job Title: National Records ManagerEpiq is seeking a highly skilled National Records Manager to oversee the operational and strategic records and information management services at our client sites. This role is responsible for ensuring that clients receive the optimal level of service in support of receipt, arrangement, storage, preservation, destruction,...


  • Pasco, Washington, United States Epiq Full time

    Job Title: National Records ManagerEpiq is seeking a highly skilled National Records Manager to oversee the operational and strategic records & information management services at our client sites. As a key member of our team, you will be responsible for ensuring that our clients receive the optimal level of service in support of receipt, arrangement,...


  • Pasco, Washington, United States MultiCare Health System, Inc. Full time

    Medical Staff Coordinator Job SummaryWe are seeking a highly organized and detail-oriented Medical Staff Coordinator to join our team at MultiCare Health System, Inc. This role is responsible for coordinating and preparing medical staff functions, including preparing for committee meetings, taking minutes, and processing and distributing correspondence.The...


  • Pasco, Washington, United States Syntricate Technologies Full time

    Senior Android Developer Job DescriptionWe are seeking a highly skilled Senior Android Developer to join our team at Syntricate Technologies Inc. in Bellevue, WA. As a Senior Android Developer, you will be responsible for designing, developing, and maintaining high-quality Android applications using the latest technologies and frameworks.Key...


  • Pasco, Washington, United States PrimCorp Full time

    Job Title: Acquisition SpecialistAt PrimCorp, we are seeking a highly skilled Acquisition Specialist to join our team in Washington DC. The successful candidate will support the Integrated Services, Acquisition and Contract Resources Program Management Office (ACR PMO) in Washington DC.Job Requirements:Have at least a bachelor's degree in business,...