Location: Bangalore
Work Mode: Hybrid
ABOUT US
At Trintech we help organizations worldwide by empowering Finance and Accounting teams with technology to simplify and streamline their reconciliation and close processes.
Trintech gives people time back for what matters most. Our cloudbased platform and solutions enable thousands of clients worldwide to lead productivity transformation across their finance organizations driving efficiencies ensuring accuracy to mitigate risk and empowering strategic decisionmaking.
It is an exciting growth time for Trintech India GCC (Global Capability Centres) who support our global engineering enabling design and development with a focus on strengthening the innovation of Trintechs future technologies.
THE ROLE
Trintechs Senior Database Administrator role affords a motivated and qualified candidate to work within the database team as part of a globallydistributed team of Site Reliability Engineers responsible for SaaS applications in a 24x7 production environments across the globe.
The Senior Database Administrator will report to the Senior Manager of Cloud/SaaS and work with the database team. In addition working with the Enterprise Architecture team in the overall Chief Technology Officers organization.
WHAT YOU WILL DO
- Performs all database administration tasks required to design implement manage and support 24x7 production environments with Microsoft SQL Server Azure SQL and Oracle.
- Drives incident response root cause analysis and advanced performance troubleshooting to proactively resolve database infrastructure problems and isolate application defects.
- Works closely with Development QA Support and Implementation teams across the full SDLC to design databases queries and maintenance plans for availability and performance.
- Develops optimizes and tests complex stored procedures.
- Creates scripts to automate data collection and database administration tasks.
- Builds and optimizes reports using SQL Reporting Services Power BI Crystal Reports and other reporting and analytics tools.
- Defines and manages maintenance plans for nonproduction and production SQL environments.
- Plan and implement backup and recovery strategies.
- Ensures security requirements are met supports audit and compliance activities and manages endtoend encryption of data at rest.
- Proactively monitors database and query performance using native and thirdparty tools.
- Performs installation configuration and patching of database server instances.
- Architects solutions for workloads that optimally leverage bare metal virtualization active/active clustering and other approaches to meet BC/DR plans and recovery objectives (RTOs/RPOs) targets.
- Leads engagements with internal customers external clients and auditors as an SME on Microsoft SQL Server technologies (database analysis integration and reporting services).
WHO YOU ARE
- Bachelors Degree in Computer Science Information Systems or a related field. Will consider an equivalent combination of education and work experience.
- Excellent written oral presentation and interpersonal communication skills.
- 35 years of experience managing Microsoft SQL Server technologies across the full SDLC.
- 35 years of experience supporting databases in 24x7 production environments.
- Experience designing building and managing database environments to meet RTOs/RPOs and Business continuity/disaster recovery (BC/DR) requirements via clustering virtualization log shipping etc.
- Experience with CDC configuration and log/data retirement
- Proficient in TSQL and/or PL/SQL. PowerShell and/or shell scripting experience.
- Experience with SQL Server clustering replication and Always On Availability Groups.
- Experience with thirdparty database monitoring tools desired (e.g. SentryOne Idera Qwest Redgate etc. it is a plus.
- Experience working in consulting or other highgrowth fastpaced agile environments where technology is leveraged as an asset to drive culture quality and velocity.
- Prior experience in organizations leveraging agile and/or ITIL/ITSM methodologies it is a plus.
- Able to adhere to technical standards that augment security and infrastructure architecture.
- Ability to strongly influence peers and technical staff within the team.
Headquartered in Plano Texas Trintech has offices located across the United States India United Kingdom France Germany Ireland Netherlands Norway Sweden Denmark Australia and Singapore as well as strategic partners in South Africa Latin America and the Asia Pacific
At our core Trintechers stand committed to fostering a culture rooted in our core values Humble Empowered Reliable and Open. Together these values guide our actions define our identity and inspire us to continuously strive for excellence in everything we do.
All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin or disability.
Required Experience:
Senior IC