Job Description
Summary: This position is responsible for the quality maintenance and performance of data stores across the organization, along with its clients and partners. As a Database Administrator, you will be tasked with enhancing data management practices and providing recommendations and best practices to development teams as required.
Responsibilities:
Perform Database capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery operations.
Act as a subject matter expert for data management and interact with internal and external teams to troubleshoot and provide best practices regarding database implementation and maintenance with our core product.
Contributes and assists with efforts/ projects in the deployment, maintenance, and support of data systems for internal and external projects.
Write and tune SQL queries and review schema designs for optimal performance.
Implement and maintain DBMS and data maintenance pipelines/processes to optimize data operations.
Plan and execute data migration plans for complex systems with large datasets.
Proactively and regularly make recommendations for data system improvements.
Collect, collate and present metrics on data systems to be used by internal and external parties.
Engage with multiple teams across the business including but not limited to the Core Development team, Managed Services team, partners and customers to provide database management best practices and enhancements.
Accountable for ensuring that all working hours are accurately reported in Netsuite on a daily or weekly basis, that the majority of (if not all) hours are tracked as billable and that the project management tool in Netsuite is properly and fully utilized.
Tracking and reporting of billable hours is a critical aspect of project management and delivery to our customers and this is a major area of accountability.
Comply with the privacy, security and confidentiality policies.
Hold all confidential information in trust and strict confidence and ensure that it shall be used only for the purposes required to fulfill employment obligations, and shall not be used for any other purpose, or disclosed to any third party. A breach of policy or misuse of information could result in disciplinary action up to and including termination of employment.
Skills and Requirements
Requirements:
A post-secondary degree in computer science or a related field combined with five to ten years of experience in database administration, information technology, database architecture, or a related field.
Extensive experience with Relational and Non-Relational database technologies
PostgreSQL**
Azure SQL
Minimum 3 years of experience with a Cloud Database Service (Azure PostgreSQL).
Strong command of SQL and database server tools.
Master database tuner, can interpret and explain plans in multiple servers and understand the query optimizations required to improve them.
Advanced knowledge of database security and performance monitoring standards.
Understanding of relational modelling and strong mathematical and statistical knowledge.
Experience with a few programming languages and the ability to troubleshoot connection strings and pools. Plusses
Experience with Data Warehousing technologies such as Snowflake or Redshift is nice to have.
Experience with cloud services (AWS, Microsoft Azure, OCI) and queuing services (Kafka, Eventhubs, ActiveMQ).
Working experience with Datalakes or BigData technologies is nice to have. 13. Excellent written and verbal communication skills and attention to detail. null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].