Database Administrator

Job description / Role

Position : Database Administrator [ SQL and NoSQL ] - MongoDB preferred

The Role:

This role is responsible for designing, deploying, and maintaining SQL and NoSQL based infrastructures in support of high volume, complex data transactions for specific services or groups of services. The position will primarily work with R&D, Architects, System Engineers, and Project Managers in a virtual team and focus on designing, building and deploying high availability, robust, resilient and supportable database solutions to support large volumes of data transactions. With a focus on the infrastructure and operational elements of designing and deploying a database solution, the DBA must ensure the databases are highly available, have sufficient capacity in place and are fully resilient across multiple data centers and cloud architectures.

This role works as part of an operations team to design, deploy and support 24x7x365 operations with Day to Day responsibilities that include;

- Manage SQL and NoSQL databases in Development/QA/Production environments including installation, configuration, backup, recovery, replication, upgrades, schema changes, etc.
- Perform database health monitoring and diagnostics.
- Integrate monitoring, auditing, and alert systems for databases with existing monitoring infrastructure.
- Design, implement, maintain and automate the appropriate backup and recovery architecture as required.
- Occasional off-shift availability to resolve Production issues or assist in Production deployments. On-call duties will be shared within the operations team.
- Work closely with other members of the operations team, mentor others in your areas of expertise, and be an active contributing member of the company as a whole
- Responsible for system performance and reliability.
- Responsible for databases dealing with overall operating system.
- Responsible for developing backup and recovery procedures for database environments.
- Maintains up-to-date knowledge of database administration and applies these developments to other major projects and initiatives
- Meticulous attention to detail with an appreciation for the relationship between database/system reliability and company success.
- Ensure proactive engagement in Incident Management process, working with Operational teams to minimize the impact of database outages.
- Work with Service Support teams to drive knowledge in to the Operations Center to improve 'First Contact' resolution and reduce Mean Time To Resolve (MTTR) for database incidents.
- Presents or makes recommendations on best practices regarding data management, data architecture, and data design.

Requirements

Qualifications

Must Have

- Bachelor's degree (Computer Science preferred)
- 5+ years experience as DBA
- 2+ years of production DBA experience with SQL with NOSQL experience -- Both preferred but NoSQL must have
- Experience working in production environments requiring 99.99% availability
- Previous experience deploying, administrating, tuning, monitoring, and maintaining database technologies including but not limited to;

Familiarity with using enterprise ticketing systems and resolution o Previous success with at least one deployment tool (CVS, Subversion, Clearcase and Puppet ) o Strong technical background in three or more of the following technologies (must include database administration): Operating Systems: Red Hat Linux, CentOS o Solid experience in database tuning, design, security, backup, recovery, and archival concepts and procedures. o Experience with monitoring systems (Nagios Professional, Cacti, etc.) o Experience deploying and managing MongoDB on Redhat Linux exposure to Cloud or virtual Application environments

- Familiarity with ETL processes and operations
- Excellent communication skills including the ability to effectively communicate with technical, non-technical employees and vendors.
- Strong problem solving, testing, and network troubleshooting skills.

Additional skills preferred

- Scripting/Programming experience in BASH,Python etc is highly desirable
- Previous experience in other database technologies, such as MySQL, Sybase, and Postgres, is a major plus.
- Documentation
- Application Servers and Open Source Components: Linux, JBoss. Apache Lucene, PHP, Data-Grid Technologies
- Storage Engineering: Network storage (NAS, SAN & Virtualized)
- Database Admin : Oracle w/RAC, MySQL(Other RDBMs technologies)
- Security : Encryption; Network security; Network topology; Cellular Network Connectivity
- Protocols: HTTP, SSL/TLS, RTP&RTSP, TCP, UDP, IP inc. v6, DNS, Samba, CIFS, SOAP and REST; Peer-to-Peer Networking, Edge Computing

About the Company

Algorythma is a first-rate end-to-end technology service company, Algorythma creates impactful products backed with experience from leading corporations and institutions across the globe.

Our team is passionate, highly skilled and specialized when it comes to creating technologies that deliver turnkey solutions and lead corporations through elevating change on a large scale. It's worth mentioning that, the team is driven by the desire to build exceptional products. We are committed to building market leaders in industries we operate, and we continue to evolve our technology and business models to deliver value to our eco-system.

At Algorythma, technology is at the heart of all that we do. From identifying issues that impact lives, to supporting experts in creating solutions, we focus on building products and teams that transform industries and the boundaries of business with technology.