Employment Opportunities > Database Administrator

Database Administrator

Position Overview:

Model data requirements based on functional requirement specifications, software requirements, and technical requirements. Model, design, and develop databases based on project requirements considering scalability, maintainability, security, and performance issues. Understand top database designs and types and pros and cons. Make tactical and strategic recommendations for implementing a database system to meet functional, technical and financial objectives. Understand relational modeling, object modeling, XML schemas, stored procedures, normalization, SOA, MVC, and UML.

Responsibilities:

• Own, track, and resolve database-related requests and incidents, fulfilling requests and resolving incidents within SLAs.
• Review service-related reports (e.g., database backups, maintenance, and monitoring) on a daily basis.
• Ensure that service-related issues are identified and resolved within established SLAs.
• Respond to database-related alerts and escalations, and work with the development and architectural teams to identify strategic solutions to recurring problems.
• Analyze and normalize existing enterprise data structures.

Qualifications:

• BS+ Computer Science or similar.
• 8+ years of experience in database development and support.
• Strong experience in Database Administration in SQL Server, MySQL, DB2, PostgreSQL or Oracle products.
• Experience in troubleshooting and resolving database issues, including those related to integrity, performance, blocking and deadlocking , replication, log shipping, connectivity, and security.
• Experience doing Performance Tuning and Query Optimization and using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server and related CPU, memory, I/O, disk space and other resource contention issues.
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, and replication.
• Expert experience in implementing operational automation.
• Strong knowledge of how indexes, index management, integrity checks, configuration, and patching work; how statistics work; how indexes are stored; and how indexes can be created and managed effectively.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system sprocs).
• SQL development skills, including ability to write and troubleshoot SQL code and design (stored procs, functions, tables, views, triggers, indexes, and constraints).
• Documentation skills for processes and procedures (such as creating KBs, runbooks, and topology ).
• Ability to provide database operational support to tech users.