What are the responsibilities and job description for the DBA II position at Kforce Inc.?
RESPONSIBILITIES:
Kforce has a client that is seeking a DBA II in Davie, FL.Job Duties/Responsibilities:- Performs, installs, and troubleshoots database backups to safeguard data and guarantee recoverability
- Performs database recovery as needed
- Troubleshoots issues on the database server, databases, tables and other database objects
- Performs tuning of database servers and slow queries as needed
- Performs SQL Server administrative tasks
- Performs SQL Server Reporting Service tasks to set up, maintain and deploy server and reports
- Performs SQL Server Integration Service tasks to set up and maintain server, deploy and troubleshoot packages
- Designs, deploys, and maintains SQL Server Agent jobs
- Deploys and performs tasks on servers with high availability technologies like but not limited to failover clustering and AlwaysOn
- Deploys and performs tasks for replicated databases using SQL Server Replication
- Assists other IT teams in diagnosing issues impacting IT systems
- Participates in the execution of database tasks from project plans for new or existing IT systems
- 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
- Participates in 24/7 support and on-call rotation
- Recommends potential solutions utilizing relational technology and implements them
- Collaborates with and supports data architects and application developers in the physical design of databases
- Implements the physical database design and optimization strategies as discussed with management
- Performs database conversion and migration activities
- Provides technical consultation to the development staff and other IT organizations or groups
- Monitors and tunes database performance to meet performance objectives
- Manages and monitors storage capacity on database servers
REQUIREMENTS:
- STEM Bachelor's degree or equivalent work experience is required
- 3-5 years of technical database administration experience or combination of training and experience is required
- 3-5 years of experience in an IT organization and/or equivalent application or business experience is preferred
- Requires understanding 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
- Knows how to use SSMS to monitor jobs, view history, set job notifications, set operators, enable and set Database Mail up
- Knows how to use SSMS to monitor access to the server and database
- Knows how to use SSMS and T-SQL to verify availability
- Knows how to operate and configure SQL Server services
- Understands Windows Clustering
- Knows T-SQL and SSIS to troubleshoot errors
- 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
- Knows how to use SSMS and T-SQL to run backups and recoveries
- Hands-on knowledge of Oracle Database is desirable; Version 11g and up
- Hands-on knowledge of UNIX and/or Linux bash shell is desirable
- Hands-on knowledge of NoSQL is desirable
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role.
We may ultimately pay more or less than this range.
Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs.
This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees.
Salaried personnel receive paid time off.
Hourly employees are not eligible for paid time off unless required by law.
Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable.
The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
