The Database Administrator is responsible for administering and managing the enterprise solution’s databases and data warehouse.

1. Key Responsibilities
- The Database Administrator implements, maintains, and designs databases in support of the development and installation of new systems and enhancements to existing systems.
- The database administrator (DBA) is responsible for the performance, integrity, and security of the enterprise solution’s databases.
- Plan, develop, and troubleshoot database upgrades.

2. Minimum Requirements and Critical Skills
- Extensive knowledge of database architectures and concepts.
- Minimum of five years of advanced experience in relational database design and management.
- Experience with maintenance of physical and logical storage structures, system, and database parameters.
- Solid Understanding of data layouts and knowledge of transporting data between databases and servers in an optimal fashion.
- Experience and solid knowledge of various backup and replication tools and technologies.
- Experience with performance tuning of both Application Tier and Database Tier, process and query optimization, troubleshooting of locking issues, monitoring of resource contention, analysis of queries, logfiles, trace files etc.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Experience managing a 7x24 Production support environment, and on-call support, including coordinating and messaging required for maintenance windows.
-Proficient in change management process and utilization of incident/issue management tools, promoting code to various environments.
- Candidate must be patient, meticulous and logical in their work and capable of prioritizing tasks.
- Excellent problem solving, analytical, administrative, organizational, communication, and interpersonal skills are also important.

3. Additional Knowledge & Skills
- Analytical skills, database design knowledge and object-oriented design
- Advanced knowledge of Microsoft SQL and XML
- Exceptional verbal and written communication competency
- Excellent critical thinking and diagnostic aptitude
- Fluent in English

4. Education
- B.S. (M.S. is preferred) in Computer Science or related field or equivalent experience

5. Responsibilities
- Monitor performance and tune Microsoft SQL Server effectively including databases and associated processes to provide optimal operations
- Utilize database analysis tools to assist in debugging problems and performance improvement
- Assist in development of stored procedures, routines, and processes related to SQL Server and its components
- Serve as primary technical resource for issues dealing with Microsoft SQL Server
- Assist in planning, testing, and implementing software and schema upgrades
- Assist in troubleshooting and resolving production problems
- Identify and resolve technology and operational issues specific to SQL databases to ensure that all databases are operating at full performance
- Manage SQL Server database specific disaster recovery, archival, backup, and recovery processes
- Implement and administer Microsoft native High Availability/Replication technologies
- Create, administer, and fine-tune database backup
- Restore and archive strategies and processes
- Perform database performance tuning and optimization
- Apply server and database wide settings based on dynamic need of resources – Memory, CPU, and storage
- Design and implement indexing strategies
- Review and refine indexing strategies routinely
- Plan and apply index defragging and statistic update policies
- Automate routine processes in SQL Job Agent
- Configure notifications and send out message to owner of failed jobs for subsequent troubleshooting
- Follow and implement SQL Server security best practices such as the separation and running of SQL Server services under different Active Directory accounts
- Assume ownership of root cause analysis for issues related to application performance
- Collaborate with other IT professionals to install, configure, and fine-tune SQL Server on physical and/or virtual machines

6. Job Requirements
- Strong analytical skills with attention to detail, and strong verbal and written communication skills
- Ability to determine root causes of technology issues and come up with efficient solutions
- Anticipate and mitigate risks in collaboration with other IT professionals
- Hands-on experience in transaction processing and mirroring replication
- Experience supporting very large databases in a production environment including proficiency in table partition design and implementation including creating, switching, and merging partitions
- Experience with automating database maintenance and operational tasks
- Experience with database performance tuning and optimizations techniques
- Fami