Collaborates with internal and external partners to provide support for all aspects of the core infrastructure, local and wide-area networks, hardware and software, or databases; provides customer and network administration services; conducts data system studies and prepares documentation and specifications for proposals; assists in the design, preparation, editing and testing of systems and computer programs.
•Administers, manages and monitors all systems, including databases, in development, test and production environments
•Monitors and manages system backups and recovery, including databases
•Designs, implements and manages system (including databases) security requirements and control mechanisms, including, but not limited to, users, groups, roles, and permissions in all environments
•Reviews project requirements and develops and recommends alternative solutions
•Oversees all activities relevant to testing a system or solution; collaborates with application developers to ensure that all programs and/or databases comply with all standards and function correctly
•Collaborates with internal and external partners to ensure customer needs are met by reviewing requirements, statuses and associated issues
•Develops and improves the effectiveness of changes to specialized systems and databases that result in solving specific business problems; recommends improvements accordingly
•Researches and recommends IT tools to improve the efficiency of programs and databases
•Keeps abreast of technology, customer needs and industry related trends
•Completes other duties, including special projects, as assigned by Management
Bachelor’s Degree in MIS, Computer Science or equivalent education and experience
Tasks and Experience
•Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
•Manage Always On, Disaster Recovery Environment, Replication and various public cloud connectivity
•Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
•Upgrade SQL Application server to newer versions as required.
•Identify and fix SQL Server performance issues, query optimization and stored procedure performance improvement.
•Automate database task, Backup, Restore operations of production databases to other environment for testing and development purpose.
•Assist developers with complex query tuning and schema refinement.
•Perform scheduled maintenance and support release deployment activities after hours.
•Partner with Business Analysts, Developers, and QA team.
•Work with vendors like Microsoft to escalate and resolve issues as required.
•Document design, deployment guide and release notes.
•Demonstrated expertise with Word, Excel, and other MS Office suite applications
•Excellent communication skills, both written and verbal, and the ability to research and resolve issues
•Well organized with the ability to work under pressure and meet tight deadlines
•Attention to detail with emphasis on accuracy and quality
•Ability to work in a fast-paced environment
•Exceptional customer service skills
•Good understanding of intra-department and operations
•Ability to perform repeated bending, standing and reaching
•Ability to occasionally lift up to 40 pounds
This job description is intended to describe the general nature and level of the work being performed by the individuals assigned to this job. This is not an exhaustive list of all duties and responsibilities. Management reserves the right to amend and change the duties and responsibilities of this job to meet business and organizational needs as necessary.