DBA

Job Description: Database Administrator

The Database Administrator will be responsible for the installation, upgrade, administration and performance tuning in SQL Server and Azure environment. Responsible for oversight and delivery expectations. Responsible for backup and restore of database environments, cloning instances to update Test and Development environments, working closely with Application Support teams to do DBA development activities such as Performance Tuning, Data Modeling, and Database Design. Highly experienced supporting fast paced hands-on client environment.

Required Technical Knowledge

• Expert knowledge of SQL Server databases (7-10 years required)
• Expertise in relational database environments
• Advanced Windows and scripting skills to support SQL Server
• Ability to implement comprehensive Backup/Restore mechanisms
• Experience working with Microsoft support: opening, managing, and resolving SQL Server issues
• Broad use of SQL Server on Windows 2012-2019 environments
• Support and implementation of SSIS/SSRS/SSAS
• Experience with business continuity planning
• Well versed in disaster recovery planning

Key Responsibilities

• Manage and support multiple Development, Test, and Production SQL applications environments
• Monitor and report system resource consumptions to assure databases meet requirements
• Identify, analyze, and interpret trends or patterns in complex data sets
• Identify and define database processes improvement opportunities
• Perform cloning, patching, and code migration as necessary to support business requirements
• Upgrades and patches to SQL Server and Azure installations
• Work with IT applications teams to ensure database requirements are met
• Perform security reviews and protect data from inappropriate access or data loss
• SQL and T-SQL Scripting as necessary to support customer
• Coordinate with the database developers and ensure implementation of standards and modular structures
• Create and manage the Data Flow & Data Modeling for multiple systems
• Approve database structure changes and updates prior to production migration and review updated/created documentation
• Manage AND update the entity relationship diagrams (ERDs) (logical AND physical) for SQL Server and other databases
• Be prepared for emergency support 24/7 with strong understanding of backup and recovery best practices

Minimum Qualifications

• 7-10+ years’ experience as a DBA
• Experience in the development of databases objects including stored procedures, triggers, views, and functions
• Experience with trouble shooting database performance issues including optimization
• Experience with creating database documentation including ERD’s, data flow diagrams, and architecture diagrams
• Detail oriented and effective time management and organizational skills
• Exceptional written, verbal, and interpersonal communication skills
• Dedicated, self-motivated and efficient
• Ability to plan, generate plans, and follow-through even in chaotic times

Educational Requirements

Bachelor’s degree

Primary Work Location: 2013 Citywest Blvd., Houston, TX 77042 (this role is onsite 4-5 days a week)

Type: Full-time employment only, no contractors or agencies currently

PCS Core Values:

• Initiative – You take initiative as an owner and do not wait for direction to act.
• Accountability – You own all the actions and results associated with your job, including the by-product of your work at PCS.
• Can-Do Attitude – You believe in yourself and always demonstrate an achievable attitude.
• Positive and Motivated – You continuously radiate positive energy and raise the level of performance of those around you by keeping yourself and others positively motivated towards your daily, weekly, monthly, and yearly goals.
• Say-Do Ratio – Do what you say and say what you do. You constantly deliver results that match the words you speak. You then keep your promises to deliver on time or keep your peers and management updated to avert a crisis.
• Integrity – You are consistent and uncompromising in your strong personal and company values as well as ethical and business morals.
• Honesty – You are always truthful and transparent in your actions during the difficult times, not just the good times.

Company Background

PCS Software, Inc. is an AI platform for the transportation logistics marketspace providing the trucking industry’s most effective transportation management platform (TMP) to improve fleet management and delivery systems and increase profits for our customers. Through innovation and invention, our software individualizes work routines, consolidates workflows, and streamlines management controls to improve accountability, transparency, and eliminate costly and redundant manual processes.

Trucking companies and freight brokers trust PCS to optimize their dispatch, accounting, and fleet operations. TL, LTL, Intermodal, and freight brokerage services use our TMP to automate operations, easily access information, and reduce inefficiencies to maximize sales and revenue. Founded in 1997 and located in Houston, Texas, PCS Software is the leading developer of hosted software solutions designed specifically for the ground transportation industry.

Why Join PCS?

PCS Software, Inc. is the perfect combination of a hyper-growth company with a fun work environment that rewards your hard work with amazing opportunities for career growth and personal development. If you want to be the newest member of a vibrant group of energized technology leaders in an innovative and entrepreneurial environment, then apply online today to start building solutions that customers will love to use and join a company that truly rewards your hard work and values your talented contributions. If you would like to compete for this highly sought-after position, please submit your resume to employment@pcssoft.com.

PCS Software, Inc. is also considered one of the best places to work because of our competitive compensation plans, comprehensive benefits plan with 100% company paid medical, dental, and vision premiums for you and your dependents, 401k with a 4% match, generous PTO package, a truly creative and fun working environment, complementary food/beverages in the office, paid training and development opportunities, paid gym/fitness facility membership, employee recognition programs, and amazing opportunities for career growth and personal development.

Work Authorization

No calls or agencies please. PCS Software, Inc. will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.

This job description provides many examples of the types of responsibilities required but is in not intended to be a comprehensive list. The incumbent will complete other job responsibilities as needed which are not specifically described in this document.

PCS Software, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability, or protected veteran status. We are committed to providing a workplace free of any discrimination or harassment. We thank all respondents for their interest in PCS Software, Inc. However, only those selected for an interview will be contacted.