Database Administrator

COMPANY DESCRIPTION

Ascentis is the leader in powering CRM & Loyalty programs for leading brands in Singapore and the region. Our clients benefit from our suite of cutting edge solutions in CRM, Omni-channel Loyalty, Integrated Retail eCommerce, Business Intelligence, Mobile Engagement, and Digital Marketing Services. Voted by senior industry marketers as one of Singapore's award-winning loyalty marketing agency, Ascentis is proud to be leading the customer engagement innovation in the retail, food & beverage, entertainment, and hospitality industries. We are a young spirited company with a culture of innovation. Our teams are driven by experience and passion. We are agile and passionate in what we do. We believe in our people. We believe in ourselves. Our clients believe in us.

As we continue to scale, we are interested to seek dynamic individual and self-starter to join us on an amazing journey by building great products for clients who believe in us.

DESIGNATION : Ascentis - Database Administrator

RESPONSIBILITIES

As a SQL Server Developer/DBA, you will design, implement and administer highly available systems and be responsible for the health, care and feeding of all our databases. You will work with fast-paced, skilled team of engineers and developers across multiple high-profile projects and products.

Job Scope:

- Strong SQL Server development experience; crafting and optimizing table structures, queries, and views to support data processing and reporting requirements
- Knowledge in creating all SQL server objects such as functions, views, synonyms, etc
- Perform data migration and testing of static data and transaction data from one system to another
- Strong technical understanding of data integration standards, frameworks and best practices; especially as they relate to ETL
- Ability to explore and propose automation scripts; optimize database systems for performance efficiency
- Create, maintain, and administer SQL Server databases
- Ensure the databases are highly secure, available, and recoverable
- Ensure the database are highly secure, including but not limited to DB user account management and database hardening
- Responsible for database health, storage and capacity planning, schedule and manage regular maintenance
- Provide database operation, including proactively monitor, troubleshooting and tune the databases for maximum performance
- Install, configure, and patch database software and complete database migrations and upgrades
- Support products development, with a focus on helping the team interact with the database in the most efficient and productive way possible
- Deploy the database components for new versions of products to test and production environments
- Able to work on non-office hours or standby for maintenance and support when is required
- Communicating the hardware prerequisites and requirements to the systems administrator to ensure efficiency

QUALIFICATIONS
- Possesses good oral and written communication skills
- Contributes to a positive team environment
- Enjoys finding and implementing solutions to new challenges
- Sets goals and focuses on results
- Proactively asks questions and learns about our products
- Effectively multi-tasks and adapts to change
- Strong problem solving and troubleshooting abilities
- Ability to work productively on various projects simultaneously
- Able to perform Storage and capacity planning

Experience and Technical Competencies:

- Up to 4 years of experience in SQL Server development and administration
- Knowledge of relational database management concepts and theories
- Expertise with Structured Query Language (SQL) and Transact-SQL (T-SQL)
- Microsoft Certification is an added advantage
- Experience in cloud (AWS, Azure) technologies is desirable
- Demonstrated desire and ability to learn technologies quickly