At Technical Resource Solutions we believe that great talent is the key to our success. We are excited to welcome you to our job openings page, where you will discover opportunities to join our dynamic and innovative team.
As a company dedicated to our mission and values, we strive to create an inclusive and collaborative work environment that fosters growth, creativity, and excellence. We value diversity and are committed to providing equal employment opportunities to all individuals.
By joining our team, you will have the chance to work alongside talented professionals who are passionate about making a difference. We encourage our employees to bring their unique skills and perspectives to the table, as we believe in harnessing the power of diverse ideas to drive innovation.
Join us on this exciting journey as we continue to shape the future of the information technology field. We look forward to receiving your application and getting to know you better. Thank you for considering Technical Resource Solutions as your potential employer.
Should you have any questions or require further information, please don't hesitate to reach out to our Human Resources department at 518.356.9970. Our team is here to assist you throughout the application process.
We wish you the best of luck in your career endeavors, and we hope to welcome you to ourTechnical Resource Solutions family soon!
Sincerely,
Technical Resource Solutions, Inc.
The dba/Database Architect will serve as the liaison between all IT Department Heads and other non system technical stakeholders through a collaborative process for the purpose of maintaining security, efficiency, system performance, building partnerships, implementing and maintaining services. Areas of responsibility include but are not limited to: •Analyze existing long running SQL driven processes and rearchitect the design of the schema and existing SQL to achieve the high availability of data performance metrics •Performance management and tuning: Proactively monitor and/or continuously assess the database environment and promote changes to data structures, SQL, Views, application logic or the DBMS subsystem to optimize performance. •Ensuring availability: Optimize data availability using non-disruptive administration strategies. •Database schema creation and management: Translate a data model or logical database design into an actual physical database implementation and manage that database once it has been implemented. •Backup and recovery: Implement an appropriate automated database backup and recovery strategy based on data volatility and application availability requirements. •Ensuring data integrity. Enforce database integrity including entity integrity, referential integrity, check constraints, and database triggers. Furthermore, the DBA must ensure the structural integrity of the database. •General database management: Understand the basic tenets of relational database technology and be able to accurately communicate them to others. •General systems management and networking skills: Integrate database administration requirements and tasks with general systems management requirements and tasks (like job scheduling, network management, transaction processing, and so on). •Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. •Manage production, QA and development database environments. •Create detailed documentation including diagrams of database infrastructure. •Learn relevant business processes and understand the data flow, criticality and dependencies. •Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
•Bachelor's degree in business or related field, or an MBA
•Minimum of 5 years of experience in database administration with PostgreSQL in a hosted AWS environment on EC2
•Project Management skills
•Exceptional interpersonal and communication skills
•Proficiency with MS Office Tools (Excel, Word, PowerPoint, Project) and related software
•Home office including reliable internet connectivity
•Some travel (up to 20%) may be required
Remote Position Posted 9/21
Remote Position 9/21 Posted
Miami, Florida
Raliegh, NC
Raliegh, NC
Copyright © 2023 Technical Resource Solutions - All Rights Reserved.