The job below is no longer available.
You might also like
in Irving, TX
SQL Server DBA (Mid Level) - PERMANENT Job
•30 days ago
Hours | Full-time, Part-time |
---|---|
Location | Irving, TX Irving, Texas |
About this job
SQL Server DBA (Mid Level) needed for a direct hire opportunity with Yoh's client located in Irving Texas.
Top Skills You Should Possess:
- Microsoft SQL Server 2008
- MySQL
What You'll Be Doing:
- Administers Microsoft SQL Server and MySQL databases
- Responsible for database integrity, security, disaster recovery, and performance tuning
- Develops and enforces database administration and user standards and procedures
- Audits, modifies, and amends data in systems using SQL commands, hand-editing, and bulk import
- Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites
- Assists developers in creating stored procedures and SQL commands to properly query databases
- Fluent in backup/restore and log shipping procedures
- Idera and Redgate tool sets
- Creates documentation on database recovery and architecture.
- Design and develop advanced database solutions including T-SQL stored procedures and triggers
- Monitor and maintain security and performance needs of relational databases
- Monitor long running transactions and have the ability to optimize query executions with index tuning and optimized T-SQL coding techniques
- Map out "conceptual design" patterns for hierarchies and other complex no relational types of models
- Install and maintain new versions and upgrades of SQL Server and MySQL
- Write database documentation including data standards, procedures, and definitions for a data dictionary.
- Control access permissions and privileges
- Develop, manage, maintain and test backup and recovery plans
- Capacity Planning
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
- Other duties as required
What You Need to Bring to the Table:
- BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
- Strong understanding of database structures, theories, principles, and practices
- Understanding of, and experience with, server-client computing and relational database environments
- Experience with data management and data processing flowcharting techniques
- Knowledge of reporting and query tools and practices
- Good understanding of the organizations goals and objectives
- Good interpersonal, written, and oral communication skills
- Technical documentation skills
- Ability to present ideas in user-friendly language
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
- Good written and oral communication skills
- The ability to create database and security standards for SQL Server environments
- The ability to develop stored procedures, triggers, indexes, and views in support of application development projects.
- Experience in developing and maintaining relational structures including backup/recovery and log shipping procedures.
- Understanding of Mortgage Originations and Servicing is a plus
- SDLC and Change Management
Bonus Points! Otherwise Known As Preferred Qualifications:
- Five to Seven years of Microsoft SQL Server experience
- Five to Seven years of IT operation experience
- Power shell
- SSIS
- Microsoft Reporting Services
- Report Writing
Get Hired, Apply Now!
Recruiter: Blake Joines
Phone Number: 972-473-4019
Yoh makes finding and applying for jobs simple. Partner with Yoh to find the right opportunities across multiple industries in the US and UK. Find out more !
Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer, M/F/D/V. to contact us if you are an individual with a disability and require accommodation in the application process.
J2W: INFOTECH
TAX TERM: FULLTIME
J2WBRDAL
Ref: 1050243
Branch: IT & Telecom