Growexx is looking for a smart and passionate Database Administrator, who will be working with cross-functional teams to define, design, and deliver new features and adopt the best practices of Test-Driven Development to guarantee the robustness and stability of the code produced.
Key Responsibilities
- Responsible for DB Monitoring and Health Checks – CPU, disk, memory, network bandwidth, etc.
- Responsible for setup alerting on health checks, and follow-up if the system is overtaxed
- Find the root cause for alerts and resolve the problem.
- Responsible to review bottlenecks on a regular basis and resolve not limited to table schema, indexes, etc.
- Design & Architect databases or tables for new tools being implemented. Be able to implement data flow to the new entities, write all relevant queries for this flow and automate as needed
- Knowledge of DB parameters. Regular monitoring of DB and tweaking of these parameters as needed to get optimal performance
- Regular data quality checks
- High-priority data should be checked for accuracy, completeness, timeliness, and consistency
- Develop and test database migration procedures, and migrate datasets to different instances as per business requirements
- Do referential integrity checks when integrating new applications with current systems
- Troubleshooting and fixing live issues
Key Skills
- Strong proficiency in RDBMS/ NoSQL.
- Understanding of the underlying storage engines and how data is maintained.
- Experience with replication configurations
- Knowledge of Data modeling and database design
- Metadata management and repository usage
- Experience in Database schema creation and management
- Strong knowledge of backup, recovery, and upgrade procedures
- Performance management and tuning
- Proficient in writing and optimizing SQL statements.
- Ensuring data integrity – Be able to maintain various data checks and deploy multiple types of database integrity including entity integrity, referential integrity, check constraints, and database triggers.
- Ability to plan resource requirements for future growth.
- Familiarity with other SQL/NoSQL databases is a plus.
- Knowledge of limitations of the Database being used and how to implement workarounds as needed.
- Proficient understanding of code versioning tools (Git/SVN/SourceSafe)
- Ability to create stored procedures and triggers and a clear understanding of the performance trade-offs.
- Ability to create scripts for automation purposes.
Education and Experience
- 5 years as a Database Administrator or similar roles
- Certification in Database Administration (Oracle/SQL/Snowflake)
- Database logical and physical design, BI design, data source analysis, and overall data management
- Expertise in different O/S such as windows, Linux, Unix, and Solaris
- Expertise in DB modeling tools & concepts
- Familiar with Business Intelligence tools
- Preferred: Experience with Data Warehousing
- Preferred: Experience with Cloud Platform
- Engineering Degree in Computer Science, or equivalent work experience
Analytical and Personal skills
- Must have sound logical reasoning and analytical skills
- Good communication skills in English – both written and verbal
- Demonstrate Ownership and Accountability of their work
- Attention to details