Job Information
Port of Seattle Database Engineer in Seattle, Washington
Some of what you'll be doing:
As a Database Engineer, you will be responsible for designing, implementing and maintaining highly available and secure database solutions that align with established guidelines and business continuity objectives.
You will collaborate with cross-functional teams to design and architect Highly Available and Disaster Recovery (HA/DR) compliant database platforms, aligning with established HA/DR requirements and business continuity objectives. You will also collaborate to support database-related projects and initiatives and ensure that database solutions meet business requirements.
You will implement database solutions using appropriate technologies. You will also define standards and best practices for database development.
You will develop and maintain processes to ensure accurate data extraction, transformation, and loading.
You will design, implement, and maintain database backup and recovery procedures to ensure data is protected from loss or corruption.
You will implement and maintain database security measures, including access controls, authentication, and encryption, to protect sensitive data from unauthorized access.
You will monitor database performance and availability, proactively identifying and resolving issues, and ensuring that databases meet the organization's uptime and reliability requirements.
You will create and maintain technical documentation, including database design documents, installation and configuration instructions, and operational procedures, to facilitate knowledge sharing and ensure compliance with industry and organizational standards.
Who you are:
Experienced – You have two (2) years of experience in Information Technology.
Desired – We hope you have a Bachelor's degree in Information Technology, Computer Science, or Business Administration. We also hope you have experience in database engineering or administration.
Committed to Equity – You will apply equity and exemplify shared values, behaviors, and practices in all aspects of the work. At the Port of Seattle, equity is a daily responsibility and a foundational expectation for all Port employees.
Expertise – You have expertise in server and data server virtualization, database backup, recovery, and planning. You understand data security, access control, and encryption. You are proficient writing T-SQL queries and have experience with cloud-based databases like Microsoft Azure SQL and Amazon Web Services (AWS). You are experienced in database migration, automation and scripting. You can develop and maintain ETL (extract, transform, load) processes using tools such as Python, PowerShell, or SQL Server Integration Services (SSIS). You have knowledge of data compliance standards such as Payment Card Industry Data Security Standard (PCI-DSS) and Health Insurance Portability and Accountability Act (HIPAA). You are also familiar with big data technologies (e.g., Hadoop, Spark) and NoSQL databases (e.g., MongoDB, Cassandra) and data warehouse and data modeling design techniques.
Collaborative – You collaborate effectively with other teams and departments within the organization to achieve goals and successful outcomes.
Effective Communicator – You have strong communication and interpersonal skills, with the ability to interact effectively with cross-functional teams.
Problem Solver – You possess strong troubleshooting skills, with the ability to quickly identify root causes of issues and provide a resolution in a high-pressure environment. You also have strong decision-making skills to make informed and timely decisions based on available data.
Highly Organized – You have strong time management skills, with the ability to prioritize tasks and manage multiple simultaneous projects.
Continuous Learner – You have a demonstrated commitment to continuous learning and staying updated with emerging database technologies, industry trends, and best practices.
What else you need to know:
Work Schedule – Your normal work schedule will be Monday – Friday, 8:00 a.m. to 5:00 p.m. (40 hours per week). Slightly more flexible start and end times are available in this role. You may be required to work during emergencies. You will have to respond promptly while on call to any IT outages, even outside regular work hours and must be prepared to be onsite if necessary to resolve technology issues.
Work Environment - This work will take place in a hybrid/in-office setting at Management’s discretion.
Washington State Residency Requirement – Employees must establish a residence in Washington state within 30 days of their first day of employment and must maintain a residence in Washington State during their employment with the Port of Seattle. If a position is eligible to telework, work performed while teleworking must be performed in Washington State.
Security Requirements – As the successful candidate, you must pass a Transportation Security Administration (TSA) background check as well as a criminal history background check with the Federal Bureau of Investigation (FBI). Your employment will be contingent upon obtaining a Port of Seattle ID badge upon clearance.
Security Requirements – In this role, you will be required to access Port of Seattle Police Department equipment, office locations, systems and/or vehicles. In compliance with Federal and State laws as the successful candidate, you will be required to pass a Criminal Justice Information Services (CJIS) criminal history background check.
Why you'll love it here:
The Port of Seattle offers an extensive benefits package that rewards our staff for their valuable contributions towards the Port‘s mission. In addition to the summary below, benefit details for non-represented positions can be found on the Port of Seattle‘s website. If the position is represented by a union, please refer to the “ Collective Bargaining Agreement ” or contact the appropriate Union Representative for specific information related to benefits and eligibility.
Healthcare – Medical, Dental, and Vision Care with options that work for you and your family.
Paid Vacation – Just about four weeks per year that increases with tenure to rest and rejuvenate.
Paid Sick Leave – At least one hour of sick leave for every 40 hours worked.
Holidays – More than ten days per year to celebrate with family and friends away from work.
Pension/Retirement Plans – A pension and additional savings plans to prepare for your future after the Port.
Getting to Work – Eligible for free or subsidized parking at your primary Port work location, validated parking for official Port business at alternate locations, as well as a low-cost public transit card.
Parental Leave – Six weeks of paid leave to spend with new additions to your immediate family.
Development – From tuition reimbursement, training, stretch assignments and internal internships, we support a learning culture.
Equity, Diversity, and Inclusion – The Port of Seattle values diversity as a source of innovation and strength. We are actively working across the organization to create a culture where all employees – regardless of race, gender, and other identities – succeed and reach their fullest potential.
Work-Life Balance – We provide the resources to help you create habits to be healthy and balanced.
Mission Driven – We are focused together in promoting economic opportunities and quality of life in the region by advancing trade, travel, commerce, and job creation in an equitable, accountable, and environmentally responsible manner.
Why the Port of Seattle:
Every role at the Port of Seattle is vital to our thriving community. We are a leader in moving people and cargo across the country and around the world. With facilities and property ranging in scope from a half-acre park to one of the largest airports and container terminals on the West Coast, we maximize the public assets in our portfolio with an eye toward best uses and environmental sustainability. Find out more here .
Our vision is to create a Port that mirrors – throughout its breadth of operations and services and within its leadership – the diversity of our communities, instill principles of equity into its culture, and ensures a fair and intentional distribution of opportunities to expand economic develop and quality of life for all in our region. Find out more about how our values RAISE us up and our commitment to equity .
Location: Downtown Seattle
Organization: ICT Enterprise Infrastrutr Svc
Employee Status: Regular
Schedule: Full-time
Posting Expires: Sep 22, 2024, 11:59:00 PM
Minimum Salary: 100,213.00
Midpoint Salary: 135,582.00
Req ID: 002863
The Port of Seattle is an equal opportunity employer that values diverse perspectives and life experiences. We encourage people of all backgrounds to apply, knowing decisions concerning the employment relationship will be made without regard to age, race, ethnicity, color, religion, creed, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, marital status, citizenship status, veteran status, the presence of any physical or mental disability, or any other status or characteristic protected by federal, state, or local law, regulations and ordinances. To help comply with all state and federal requirements, we appreciate you voluntarily answering the questions below. The information on this form will be kept confidential. Click https://www.portseattle.org/page/ethnicity-definitions for definitions and descriptions of the categories referenced below regarding Ethnicity and Race. Click https://www.portseattle.org/page/vevraa-information for information and definitions of the categories referenced below regarding Protected Veterans status.