Job Description
With a rapidly growing customer base, Transcepta is adding a Senior DBA to our Web Operations team. This position will report to the Web Operations Manager and will be responsible for the application and reporting databases performance, security and scalability. Additionally, the position will be using the latest data visualization tools to create operations and application reports
Transcepta’s SaaS solution is experiencing large year-over-year traffic growth. We are looking for someone who’s excited about high throughput SaaS solutions and has a passion to architect database systems for optimal performance. Your proven track record will be integral in transforming Transcepta’s SaaS solution to meet our rapid growth.
Job scope and responsibilities:
Daily monitoring of database and query performance using tools like SolarWinds and Splunk
Work with engineers to optimize application queries
Develop ETLs to load the data warehouse with data optimized for reporting
Develop data visualizations and reporting for both customer facing and internal teams
Analyze DB for security vulnerabilities
Execute schema migrations as part of application release process
Setup, Optimize, and monitor DB replication to other regions or environments
Experience and education:
Bachelor’s degree computer science/engineering. Masters preferred
4+ years work experience as a SQL Server DBA
2+ years ETL experience with Talend, SSIS or similar
2+ years reporting writing experience with SSRS, Power BI, Tableau or similar
AWS or Azure cloud experience a plus
Detail oriented with strong organizational skills
· Detail oriented with strong organizational skills
Personal characteristics:
Smart – Easily grasps complex technical and business problems and quickly arrives at viable solutions.
Ethical – Consistently demonstrates high standards of personal integrity.
Gets Things Done – Can manage many projects at once. Liaises with the Transcepta IT, Dev and Business teams to maintain SaaS Database uptime, performance and security. Delights our customers with inciteful data visualizations.
To be considered for employment, applicants must be authorized to work lawfully in the United States and do not now, or in the future, require work visa sponsorship (such as an H-1B visa).
Company Description
Transcepta is the leading global supplier network. With cutting-edge supplier on-boarding programs, revolutionary technology, and free membership for all suppliers, Transcepta connects customers with all of their suppliers, faster than any other network. Transcepta provides accounts payable and procurement professionals with industry-leading procure-to-pay (P2P) solutions in the cloud, including e-invoicing, spend management, VAT compliance, supplier information management, supplier enablement, supply chain financing, and dynamic discounting. Businesses collaborate and transact electronically over the Transcepta Network to reduce costs, communicate more efficiently, and make their relationships more productive. Since 2005, Transcepta has connected the global supply chain and processed millions of transactions to become the fastest-growing supplier network.