Trissential's a trusted partner for end-to-end quality services and management consulting for digital transformation. As a part of our parent company Expleo, we're a global organization partnering with major corporations and leading non-profits in over 30 countries. Guided by our mission and values, Trissential puts people at the heart of our organization.
Come join an experience. Add your talent to a team of forward-thinking game changers that make an impact by driving innovative solutions.
Trissential is currently seeking a Senior Database Administrator to join our dynamic team in Minneapolis, MN or Denver, CO (Hybrid - Onsite 3 days, Tuesday, Wednesday, and Thursday)
ResponsibilitiesJob Summary:
- The existing OT DBA (Operations and Technology Database Administration) Team supports the client's Gas SCADA environment, Transmission, DEMS/EMS SCADA environment, Distribution ADMS SCADA environment as well as nuclear applications.
Essential Responsibilities:
- Provides technical expertise and guidance in the use of database management systems.
- Responsible for database access methods, device allocation, validation checks, file organization, indexing methods, protection and security, documentation, guidelines, troubleshooting, automated backup procedures, and database design.
- Responsible for database integration and system testing.
- Responsible for activities such as building the environment, performance tuning, user administration, database refreshes, etc. within a hybrid environment which utilizes both SQL and Oracle servers.
- Manages MySQL MariaDB, as well as projects within the PostgreSQL database management system.
Required:
- Oracle OCP (Oracle Certified Professional) or Microsoft certification preferred
- SQL server -knowledge of how to manage and administer different SQL server versions; 2012, 2014, 2016, 2017 and 2019 database versions
- Oracle database administration experience
- Must understand how to perform upgrades (side by side, in place upgrades), should also know how to administer Oracle Database 19c in Linux and Windows platforms
- Must have knowledge of SSIS (SQL Server Integration Services), coding, package deployment, integrations, database mirroring, log shipping and replication on the SQL side, Data Guard on the Oracle side, how to implement tracking/tracing on the Oracle side, Windows clustering, AlwaysOn
- Experience in scripting (PowerShell), knowledge of how to write TC and PLC code
- Knowledge of how to manage PostgreSQL and MySQL MariaDB
- Knowledge of Windows + Linux platform is a must
- Experience in MySQL MariaDB in Linux environnement
- Experience in PostgreSQL and Redhat
- Experience in SQL server running in Microsoft platform
Preferred:
- SCADA exposure/experience is a plus
- Software Engineer/Java Development
- Works independently or well within a team
- Wants to continuously grow knowledge base and skill set
- Collaborative, consultative mindset
- Works well in a fast paced environment
- Strong technical background
- Deep knowledge and curiosity about technology and systems
- Agile mindset
- 8-10 years of experience in a similar role.
- SQL server database administration experience.
- Oracle database administration experience.