Database Administrator II

An extraordinarily talented group of individuals work together every day to drive TNS' success, from both professional and personal perspectives. Come join the excellence

The DBA is responsible for support, maintenance, and development of TNS’s databases which support a wide variety of TNS products. This DBA should have experience in multiple flavors of database technologies like Oracle, MongoDB, MariaDB in a Linux environment and knowledge of MS SQL Server. This person should be a self-motivated individual with good communication skills and able to work well in a collaborative environment.

1. Provide Database Administration and day-to-day support of databases mainly Oracle, MariaDB, MongoDB, and SQL Server databases.
2. Implement and support Administration tasks such as backup and recovery procedures, database utilities, and data replication technologies while supporting the development, test, and production environments.
3. Troubleshoot and provide technical support, involving effective communication to internal and external customers on SQL bugs, application issues, and identifying anomalies to implement corrective actions for all production and non-production environments in a timely fashion.
4. Manage organizational data definitions and process-flows to ensure consistency, security, and accuracy of transactional data.
5. Provide technical services to monitor and maintain environments, running on the organization's strategic platforms including periodic software upgrades, vulnerability patching, and migration of the databases.
6. Document operational or newly engineered solutions properly to educate and inform the IT Support staff at various levels.
7. Create and maintain Linux and SQL scripts to automate scheduled tasks, monitor and database alerts.
8. Log, schedule, and track all changes using change management system tools.
9. Responsible for all corrections to the database infrastructure and for repairs to the system or database.
10. Provide 24x7 on-call support in rotation for production databases.

Must possess:

1. 4+ years of advanced database administration experience with a large-scale Oracle, MySQL, SQL Server in multi-node clustered environments including replication and security.
2. 3+ years of database administration experience in MongoDB and MariaDB with development experience.
3. Strong skills in SQL Maintenance, Back-up, SQL Stored Procedures, High-Availability, Performance Tuning, and Future Architecture Design and Expansion.
4. Working knowledge of data modeling; database administration problems and requirements; and database analysis and design procedures, techniques, and implementation.
5. Experience with Database Warehousing, Decision Support, and OLTP.
6. 4+ years’ experience in reviewing, writing, and debugging, tuning complex SQL stored procedures, functions, and triggers etc.
7. Experience with advanced SQL Server network connectivity and protocols.
8. Strong working experience using various database Tools and SQL Performance Analyzer etc.
9. Highly motivated with a commitment to quality service.
10. Strong knowledge of managing projects and excellent communication skills required.
11. Self-starter, able to prioritize and work well under pressure.
12. Ability to communicate orally and in writing clearly and straightforwardly.
13. Ability to handle multiple projects and tasks.

If you are passionate about technology, love personal growth and opportunity, come see what TNS is all about TNS is an equal opportunity employer. TNS evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.