Senior Database Administrator
Title: Senior Database Administrator Location: Hollywood, FL We are seeking a Senior Database Administrator who performs high-complex database management tasks, i.e. monitors and manages the integrity of all enterprise databases. He/she requires a high degree of expertise and specialized knowledge of data base management techniques which facilitate and expedite the usability, consistency, accuracy, integrity, security, timeliness and availability of enterprise data. The position performs ongoing and in-depth database analysis and is responsible to continuously mentor and lead direct reports. RESPONSIBILITIES: Works with vendors, users, applications developers and management to obtain information and develop an understanding of the needs of the organization and to overcome significant operational and/or technical issues or problems. Recommends potential solutions utilizing relational technology Assesses and assigns DBA resources and oversees quality of work produced Recommends reviews and approves the design of physical data models and structures Provides advanced level database management, support and assistance Collaborates with and supports data architects and application developers in the physical design of databases Implements the physical database design and optimization strategies Leads database conversion and migration activities Analyzes, develops and supports disaster recovery plans Provides back-up and recovery procedures as needed for all production and test databases Provides technical consultation to the development staff and other IT organizations or groups Works with management and user committees in setting performance objectives Monitors and tunes database performance to meet performance objectives Manages and monitors storage capacity Evaluates, recommends, and participates in the installation of new storage media Supports operations staff with their production databases Works with programmers to tune data access codes Participates in IT committees to create standards for database utilization Maintains strong vendor relationships to keep apprised of new database products, versions, and releases Escalates intractable problems to the vendor Evaluates, recommends, and installs new versions and releases and new database tools Develops plans to install, maintain, enhance, test and migrates DBMS products and supporting software Coordinates with engineering staff to ensure consistency in planning and implementation efforts Works with application developers and other organizations within the enterprise to evaluate database requirements for application software packages under consideration Provides second level support to the database administrator Responds to and assists with other problem tickets as required Adheres to other defined SOPs as required Performs other duties as assigned QUALIFICATIONS: Bachelors degree or equivalent work experience is required 7-10 years technical database administration experience or combination of training and experience is required 5-7 yearsâ€™ experience in an IT organization and/or equivalent application or business experience is preferred Requires strong knowledge of logical design and physical implementation Requires knowledge of enterprise hardware and operations systems Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management Self-sufficient, requiring limited supervision over job knowledge, expectations and successful project completion Knows how to use SSMS to monitor jobs, view history, set job notifications, set operators, enable and set Database Mail up Proficient with T-SQL Knows how to use SSMS to monitor access to the server and database Knows how to use SSMS to monitor the database server performance Understands locking Understands CPU time Understands wait types Understands physical reads and logical reads and writes Understands sessions and requests Knows how to use SSMS and T-SQL to verify availability Understands database states and user access options Knows how to operate and configure SQL Server services Understands Windows Clustering Knows T-SQL to troubleshoot errors Knows SSIS to troubleshoot errors Responds promptly to events Knows how to use SSMS and T-SQL to create logins and users, and to grant permissions Understands SQL Server security architecture Knows how to use SSMS and T-SQL to create and modify databases Understands application needs before implementing the database Is familiar with Best Practices for database file structure, security, etc. Is familiar with pre-installation, installation and post-installation steps Is familiar with Best Practices as far as systems databases, security, etc. Knows how to use SSMS and T-SQL to run backups and recoveries Knowledge of Oracle Database is desirable. Version 10g and up. Knows how to connect Understands Oracle database architecture Knowledge of Oracle RAC is desirable Knows how to back up the database both online and offline Knows how to restore the database Knowledge of RMAN desirable Knowledge of UNIX and/or Linux bash shell.