Overview:
Database Administrator Pittsburgh, PA/Plano, TX (Onsite/Hybrid) 6-Month Contract (Extendable)
Job ID 2024-10105
We are looking for a Database Administrator. This is a 6-month contract opportunity in Pittsburgh, PA/Plano, TX (Onsite/Hybrid).
Qualifications:
- BS in Computer Science/Computer Information Systems or equivalent training and/or experience.
- At least 5 years of experience in database design, development and general administration.
- Preferred Experience: other database platforms such as MySQL, and NoSQL technologies.
- Advanced knowledge of SSIS, TSQL, and MS SQL Server.
- Experience with SSRS, C#, and Powershell would be a plus, but not required.
- Fundamental software development methodologies, design and implementation.
- Advanced knowledge of database backup concepts, query optimization, data security and availability groups.
- Ability to manage multiple projects at the same time. Demonstrate the following skills: high level of productivity, excellent written and verbal communication skills, team player, positive interpersonal skills, self-motivated and independent thinker.
- The ability to write fully optimized SQL for various scripts and stored procedures is essential.
Responsibilities:
- Analyze and evaluate reported problems, take responsibility for resolution, and prevent recurrence.
- Develops, tests, implements, troubleshoots, and supports data extraction, transformation, and loading processes.
- Maintains database performance by calculating optimum values for database parameters; implements new releases; completes maintenance requirements.
- Proactively manages Database Performance Tuning and Optimization.
- Develops and implements database business continuity plans and procedures.
- Creates new databases, tables, views, indexes, scheduled jobs, triggers, logins, etc. based on system specifications.
- Tunes data warehouse and other database systems for optimal performance and reliability.
- Performs index and statistics maintenance.
- Develops, implements, administers and maintains operational automation scripting.
- Maintains technical documentation related to the database systems and processes.
- Provides after-hours and weekend escalation support as required.
- Coaches, trains and mentors other employees on proper access and use of database systems.
- Adhere to Scrum principles and philosophies in fulfilment of the role.
- Work as a cross-functional team member in an Agile setting to help complete and deliver the team commitments.
- Collaborate across teams and across business areas in the spirit of an Agile mindset.
- Responsible for reporting risks that are identified to the appropriate team and/or management. Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, including, but not limited to Information Security risks.
- Data Warehouse setup and maintenance.
- Set up and maintain backups.
- SSIS reporting. Existing systems in place. Need additional reports.
- Architecture issues.
- Latency
- Triggers
- SQL Calls from LOS
- Indexing
- Transact SQL Queries
Pay Range for CA, CO, IL, NJ, NY, WA, and DC: $65/hour to $75/hour. Starting rate of pay offered may vary depending on factors including but not limited to, position offered, location, education, training and/or experience.
About the Client: Our client is a Real-Estate and Mortgage company.
About Solugenix
Solugenix is an information technology services company known for its deep experience and knowledge in providing comprehensive technology services, solutions, and talent support for companies around the world. The company offers a variety of cutting edge and talent support solutions to promote growth and cutting-edge advancement to our esteemed clients and candidates. We provide these talent support solutions on a contract, contract-to-hire, and direct hire basis. We also have additional resources from our staffing partners to ensure the right match and expertise for the best result.
For over 50 years, global and local brands have trusted Solugenix as an added resource and partner in taking steps to ensure their immediate and future success. In addition to generating ground-breaking, industry-defining solutions, Solugenix has been delivering the talent and support needed to make it happen. We are dedicated to partnering with clients and candidates whose core values also foster a culture of professionalism, teamwork, and integrity.