What are the responsibilities and job description for the NoSQL DBA position at Tekcogno?
Role: NoSQL Database Administrator
Site: 14000 Riverport Dr Maryland Heights, MO (Hybrid Onsite)
JOB SUMMARY
The Database Administrator will actively engage and work with other entities within the Software Development/IT infrastructure, included but not limited to REDIS, Mongo, SQL, Oracle, Storage Data Protection, Data Center, Networking and Architecture. The role will work closely project teams to deploy new solutions as well as innovate proof-of concepts efforts within the group.
MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience.
- Focus on MongoDB/NoSQL/REDIS infrastructure and will facilitate the design and build.
- Maintain and revise configuration and security standards, guidelines, and best practices for MongoDB technology.
- Assist in the adoption of Cloud infrastructure platforms and the integration of a hybrid architecture.
- Manage and maintain MongoDB database servers in all environments.
- Performs installations and configurations of grid infrastructure, databases, clients etc.
- Designs and maintains access and security administration.
- Designs, implements and maintains backup and recovery strategies on Database Management Systems.
- Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
- Designs, installs, configures and maintains High Availability Database solutions.
- Expertise in setup and use of monitoring and diagnostic tools to identify/resolves the performance issues.
- Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.
- Performs capacity planning of server environments and provides recommendations to management to sustain business growth.
- Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.
- Gathers business requirements and designs, implements multiple projects along with the production support.
- Creates standard operational procedures and templates.
- Acts as mentor for Database Administrators and Associate Database Administrators.
- Performs research and provides plans to remediate complex business problems.
- Assists the development teams to improve database design and procedures on PL/SQL best practices etc.
- On-Call Responsibilities once you complete initial training period
REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
- Experience in installation, configuration, and administration of MongoDB or NoSQL REDIS in both on-prem experience with one or more modern scripting/automation languages (Ansible, Python, etc.)
- Experience with both sharded clusters and replica sets
- Experience in MongoDB/NoSQL/REDIS Performance tuning
- Experience with MongoDB/NoSQL/REDIS Security best practice implementations
- Experience with MongoDB/ NoSQL Backup, Restore and Monitoring
- Experience with Ops Manager
- Experience with database performance, scaling, and tuning concepts
- Experience working in AWS, Azure and/or any cloud provider environment
- Experience with virtualization and container environment management (e.g. VMware, DC/OS, Kubernetes, CAAS)
- Experience with database monitoring and alerting
- Experience with one or more modern scripting/automation languages (Ansible, Python, etc.)
- Demonstrated knowledge of database architecture and its implementation
- Demonstrated understanding of best practices in maintaining medium to large scale Mongo database systems
- Demonstrated knowledge of PL/SQL programming language
- Demonstrated understanding of Change Management procedures
- Demonstrated knowledge of Instance, database and query tuning to improve the performance of the database/application
- Demonstrated understanding of SAN technologies related to SQL server disk layouts
- Demonstrated knowledge of Windows/Linux/Solaris operating systems and shell scripting
- Ability to communicate orally and in writing in a clear and straightforward manner
- Ability to communicate with all levels of management and company personnel
- Ability to handle multiple projects and tasks
- Ability to make decisions and solve problems while working under pressure
- Ability to prioritize and organize effectively
- Ability to show judgment and initiative and to accomplish job duties
- Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.)
- Ability to work independently
- Ability to work with others to resolve problems, handle requests or situations
- Ability to effectively consult with department managers and leaders
Required Education
BA/BS in Information Technology, Computer Science, or related field or equivalent work experience
Required Related Work Experience and Number of Years
3-6 years of Experience working with Mongo, Redis, Oracle and various database management systems in testing, implementation, maintenance and administration in a multiple platform environment
WORKING CONDITIONS
Office environment
24x7 on-call support
Job Types: Full-time, Contract
Pay: $90,264.12 - $130,000.00 per year
Schedule:
- 8 hour shift
- On call
Ability to commute/relocate:
- Maryland Heights, MO 63043: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- What's your visa status and current location?
Experience:
- MongoDB: 3 years (Required)
- Redis: 3 years (Required)
- Oracle DB: 3 years (Required)
Work Location: Hybrid remote in Maryland Heights, MO 63043
Salary : $90,264 - $130,000