Install, configure, troubleshoot, and maintain database systems. Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Monitor and optimize system performance using index tuning, disk optimization, and other methods. Set user privileges within the database environment.

Responsibilities

·         Maintain a high level of performance with our ShoWare product

·         Monitor and profile production database servers for load and performance bottlenecks

·         Disaster Recovery

·         Daily database server health checks for: backups, jobs, mirroring, replication, etc.

·         Assist application developers with database schema and procedure changes according to company conventions and best practices

·         Analysis and approval of database schema and procedure changes from dev to staging to production environments

·         Write and update advanced stored procedures for business reporting purposes

·         Responsible for database server upgrades from SQL Server 2005 to SQL Server 2008

·         Provide 24x7 support and maintenance for production databases

·         Maintain and monitor database backups and rotating archives of backup files

·         Develop & execute test cases from supplied documentation and testing experience

·         Participate in full test cycle, including: Unit Testing, Integrated System Testing, and User Acceptance Testing

·         Code Reviews

·         Documentation of all testing performed during effort

·         Defect tracking from initiation to completion

·         Interfacing with management, project managers, and developers

·         Working with automated testing tools

·         Hands on client testing

·         Backend server testing

·         Complies with company policies and procedures and maintains regular work attendance

·         Performs other development duties as assigned

Common Responsibilities

1. Install all new hardware, systems, and software for networks.
2. Install, configure, and maintain network services, equipment and devices.
3. Supports administration of servers and server clusters.
4. Manages all system back-up and restore protocol.
5. Plans and supports network and computing infrastructure.
6. Perform troubleshooting analysis of servers, workstations and associated systems.
7. Documents network problems and resolution for future reference.
8. Monitors system performance and implements performance tuning.
9. Manage user accounts, permissions, email, anti-virus, anti-spam.
10. Requires a thorough knowledge of networking essentials.
11. Assist software and network security.
12. Strong analytical abilities and professional office experience needed.