Professional MS SQL SERVER DBA Essential Job Functions Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files. Develops complex data retrieval queries and optimizes data queries within programs for performance and maintainability. Determines data to collect and analyzes information as appropriate. Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for complex databases. Recommends and implements course of action based on analyses. Defines logical attributes and inter-relationships and designs complex data structures to accommodate database production, storage, maintenance and accessibility to enhance performance. Tests designed applications utilizing database management software and/or general programming software to enhance performance. Determines test's) to use and collects appropriate data as has been established. Installs, implements and supports complex systems within user base; creates and updates database installation instructions and design changes for client use. Monitors and coordinates installation and upgrades of hardware and software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products. Provides work guidance and leadership to less experienced personnel. Acts as technical project leader on assigned projects. Utilizes standard corporate tools to record change and problem activities for tracking purposes. Provide technical support for SQL Server database environments, including testing and installation of DBMS upgrades and backup and recovery of existing databases. Assist in documenting database strategies and architectures. Monitor the performance of production systems and utilize appropriate tools to identify tuning requirements. Participate in 24 x 7 page out/call out support on a rotating basis for production database support issues. Participate in tool evaluation, integration and support. Basic Qualifications Bachelor's degree or equivalent combination of education and experience Bachelor's degree in computer science, management information systems, or related field preferred Three or more years of experience in database design or maintenance Experience working with software installation/upgrading procedures Experience working with file and system maintenance procedures Experience working with database creation techniques and database management systems (DBMS) Experience working with performance modeling and benchmarking skills and relational databases 5 years MS SQL Server 2008/2014 DBA experience on multiple databases 5 years database administration and technical support for production database environments, including performance and tuning 7 years IT experience Windows 2003, 2008 Server OS Database Backup & Recovery Performance Tuning Database Server Installation & Configuration Subsystem infrastructure (64 bit, Fail over design and Log sizing) implementation. Familiarity with SQL Server in a clustered environment Experience with Integration Services, Analysis Services and Reporting Services Experience with Enterprise environment change control procedures Other Qualifications: Good analytical and problem-solving skills Good programming skills for database management and general software Good communication skills for providing documentation to support personnel, customers, and managers Good leadership skills to guide and mentor the work of less experienced personnel Strong ability to work in a team environment Ability to anticipate problems and take decisive action Willingness to travel Excellent Client relations Excellent attendance record Positive attitude Nice to Have Skills: Programming experience in T-SQL and PowerShell Excellent communications skills (both oral and written) Good interpersonal skills Active Directory Experience Any experience with DTS to SSIS conversions Data Warehouse administration experience Microsoft certification a strong plus SDL2017
Ciudad: isabela
