Database developer/database administrator job description

At Anser Advisory, we strive and succeed by creating smart, dynamic and professionally skilled teams to deliver extraordinary projects for our clients. You will work on interesting projects which will expand your expertise and hone your technical skills through the ability to access the most advanced technology on the market. Your successful impact will help us obtain our goal of being the nationwide go-to professional services provider. Anser provides our clients with advisory, compliance, program and project construction management services at the highest level of dedication.

Our relationships are on our credibility to deliver on our commitments, with unbeatable service levels to our clients which has resulted in our rapid growth, nationwide.

We are seeking a Database Administrator/Developer for an immediate opportunity with our Orlando team that will work closely and with the project team. Responsibilities will include daily database management, troubleshooting and development of new features and reports. 5+ years of experience in providing these services for a medium sized database with 25-50 users. Additionally, experience with construction finance, accounting, grant funding, aviation, etc. is highly preferred.

This is an Orlando based project and relocation assistance will be offered or this position can be remote with potential for some travel.

Duties & ResponsibilitiesProvide database management and support to project team.Develop new reports and feature for the database based on team client feedback.Maintain daily operations of database and troubleshoot issues as they arise.Develop ways to streamline existing processes within the database.Upgrade database's existing platform to newer technology as needs allow.Perform other analysis and queries as needed by team and/or client.Perform periodic security assessments and make necessary changes to ensure continued data security.Able to present findings and recommendations to senior staff and/or clients.Interface with users to devise solutions for developing new or revising existing structure within the database to accommodate for changes to contract type, construction method, new funding requirements, etc.Candidate needs to be able to perform independently and in an deadline driven environment.Document existing and developing database schemas to communicate information to users and other database professionals.

Qualifications & RequirementsDemonstrated ability to accurately and efficiently complete deliverables and meet deadlines while producing quality materials within tight timeframes and simultaneously managing several assignments.A self-starter who solves problems and works independently.Organized and detail oriented.Must have knowledge of MS Teams, Word, Excel and PowerPoint in a corporate environment.Preferred experience with SQL and SAS and script writing in Excel to compare data sets, ASP.NET Core, Model-View-Controller (MVC) architectural pattern Must be customer focused and have the ability to identify issues and develop innovative solutions to a variety of complex matters of a diverse scope and nature and have demonstrated ability to be creative and have advanced problem-solving skills with the ability to transfer prior experience to new projects.Strong ability in establishing effective working relationships with others within and outside of the organization across all levels of responsibility.

We hire great people from a wide variety of backgrounds, because it makes our firm stronger. Each of us contributes to our inclusive environment in the way we act, our level of commitment, encouragement to others to share their ideas, and our everyday, outstanding teamwork to support our clients. We also support professional for our staff and celebrate their accomplishments.
Simply put, our firm is better...because of the people we work with.

TransCore (TRN),a subsidiary of ST Engineering, is seeking a full-time Database Administrator/Developer to join our team in Houston, Texas.

The Database Administrator/Developer provides day-to-day and on-call first line technical support for our Infinity production installations. Troubleshoots and follows through-to-resolution issues concerning the application and the database. This position will involve ensuring the database systems are configured and deployed properly with the correct parameters, configurations, SW versions and performance settings, will develop and optimize stored procedures, and will analyze the flow of the data throughout the system to validate it is functioning properly. Will analyze and assure proper database performance. Database Development and Administration duties are expected to be 40/60% respectively.
Essential Duties and Responsibilities
include the following. Other duties may be assigned.


Owns and executes daily, weekly, and monthly maintenance tasks, monitoring application performance, backups, replication and data restore, creating and granting logins and support procedures of supported SQL-based infrastructure systems. Responsible for the development and sustainment of the SQL Server Data Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling. Design and create Fact and Dimension tables; involve in maintaining and troubleshooting SSIS packages. Create and maintain proper documentation of all the SSIS and SSRS reports. Conduct analysis on data to answer important business questions and forecast business threads. Ensure that storage, archiving, back-up and recovery procedures are functioning correctly. Provide first line of software/database support for our Infinity installations during normal business and off hours. Provide support to current deployments and processes, contributing to new requests for enhancements, troubleshooting existing processes and validating system requirements. Develop and optimizing SQL queries, stored procedures and functions to support system operations and customer requirements. Experienced in HADR features like AlwaysOn implementation and troubleshooting. Create required database indexes, index management, and maintain statistics. Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues. Monitor current system installations for performance degradation and perform preventative and corrective cleanup activities to assure proper functioning of the database systems. Develops technical procedures, scripts and associated documentation to improve existing processes and implement new ones. Support Production, Data Warehouse, Development and QA Environments. Analyze Transaction Data Reports and reconcile data differences. Perform scheduled maintenance and support release deployment activities after hours.



Education
:
Bachelor's degree from an accredited college or university or equivalent combination of education and work experience.


Required Skills & Experience:



4+ years of professional experience in SQL Server Database Administration, Development and Data Warehouse configuration. 2-3 years of experience with T-SQL. Expertise in creating PowerShell scripts for automating repetitive SQL Server tasks. Expertise in creating, maintaining, and troubleshooting SSIS packages. Experience configuring and managing SQL Server Always-On Availability Groups. Experience with side-by-side and/or in-place Database Migration/Upgrade. Experience on working with data warehouse environment. Experience with using SQL Server tools and system stored procedures. Have firsthand experience with Dynamic SQL. Have experience with 3rd party tools like RedGate and SCOM. Experience with Performance Tuning and Optimization. Highly motivated team player who can establish excellent working relationships with peers and other teams. Ability to understand business requirements and estimate for delivery commitments. Excellent verbal, phone, and written communication skills. Willing to take part in 24/7 on-call rotations and shift rotations, if required. Ability to multi-task, nimbleness and highly functional within a team environment. Ability to work with minimal supervision.



Desired Skills:



Previous experience within the tolling industry


Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Clearance: Top Secret



Our client
is looking for a highly qualified, experienced, and self-motivated individual with a
Top-secret Clearance
to perform the duties of a
Senior Database Developer & DBA
to support
ATS
and our government customer onsite at
FBI Records Operation Center (ROC), in Winchester, VA
.

We offer competitive compensation and an extraordinary benefits package including health, dental and vision insurance, 401K with company matching, flexible spending accounts, paid holidays, three weeks paid time off, and more.


Position Overview:

This position is for a database developer and administrator to support the FBI's Information Management Division by applying information technology solutions to their business processes. This role is responsible for the performance, integrity, and security of databases. The DBA will provide technical expertise in the design, implementation, and maintenance of these databases and additionally would monitor and resolve all database issues and problems.


Essential Functions, Responsibilities & Duties may include, but are not limited to:

• Lead and contribute to design discussions in a cross-functional project setting
• Develop database standards, guidelines and best practices
• Design and architect solutions which often require complex system integration
• Perform capacity planning and project estimation
• Evaluate and research new database features, version and technologies

Requirements

• Experience in definition and management of database requirements, design, code, benchmark testing, debugging, software development lifecycle, architecture, and documentation.
• Provides technical/management leadership on major tasks or technology assignments.
• Establishes goals and plans that meet project objectives.
• Has domain and expert technical knowledge.
• Direct and control activities for a client and ensure technical requirements are met.
• Interact in client negotiations and interface with senior management.
• Decision-making and domain knowledge may have a critical impact on overall project.
• Demonstrate a willingness to work in a team environment and the ability to work independently while prioritizing and supporting multiple tasks

Work Experience, Knowledge, Skills & Abilities:

• 5+ years' work experience supporting Federal Customers
• Experience with MS SQL Server, SQL development, triggers, and stored procedures
• Experience with database architecture and administrator
• Bachelor's degree in Computer Science or related field

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans