Data Architect (Alexandria)

Data Architect

Lynker is seeking a talented Data Architect to join our team in support of a long term government contract. Lynker Corporation is a leading provider of innovative solutions in weather and climate science. With a commitment to excellence and a passion for innovation, Lynker leverages cutting-edge technologies and scientific expertise to support the creation and delivery of improved operational weather forecasts.

Responsibilities

The Data Architect selected will be responsible for the following :

• Leading a team of Data analysts, database administrators, and data quality analysts
• Database architectural design and construction for both new database and existing database environments
• Establish best practices for ETL processing in Oracle relational databases.
• Lead team members in developing and maintaining documentation regarding data quality assurance and data loading processes
• Coordinate with survey contractors to provide efficient and accurate data transfers and loading of survey data from SAS and other sources thru standardization / automation of ETL processing
• Mentor team members on industries best practices regarding data processing and relational database design.
• Refine / improve data standards and structures for all aspects of the data management life cycle
• Experience designing and building dimensional structures and star schemas
• Manage all transformation activities for a large Oracle 19c-based data warehouse
• Provide database support activities for all Oracle 19c database environments including
• Periodic database management such as performance tuning, backup / recovery, expansion, manage security, etc.
• Technical Support for other developers in the team
• Write, troubleshoot and improve SQL
• Provide System Administration and development support for Qlik Sense Enterprise :
• Knowledge of the following is a plus :
• Qlik Sense Enterprise
• Apache Webserver
• JBoss 6 Application server
• SAS metadata server 9.4
• SAS OLAP server 9.4
• SAS Web Infrastructure Platform 9.4
• Coordinate between with Unix System and Oracle Database Administrators for security patching and incident troubleshooting
• Responsible for managing the daily activities for a large statistical data warehouse, including (1) ensuring the accuracy of all data transfers into the data warehouse, (2) maintaining the performance of a large Oracle Data Warehouse including both database and application performance, (3) coordinating activities with survey contractors to provide efficient and accurate data transfers, and (4) provide System Administration activities for both Unix and Linux environments. Candidates for this position must possess a certification as an Oracle Database 11g Administrator Oracle Certified Professional and be able to pass a Government Background Check.

Qualifications

The Data Architect selected should have the following qualifications :

The Ideal Data Architect will have the following :

About Lynker

Lynker is a growing, employee owned, small business, specializing in professional, scientific and technical services. Our continually expanding team combines scientific expertise with mature, results-driven processes and tools to achieve technically sound, cost effective solutions in hydrology / water sciences, geospatial analysis, information technology, resource management, conservation, and management and business process improvement.

We focus on putting the right people in the right place to be effective. And having the right people is critical for success. Our streamlined organization enables and empowers our talented professionals to tackle our customers' scientific and technical priorities creatively and effectively.

Lynker offers a team-oriented work environment, and the opportunity to work in a culture of exceptionally skilled professionals who embrace sound science and creative solutions. Lynker's benefits include the following :

Lynker is an E-Verify employer.

Lynker is an equal opportunity employer and makes all employment decisions based on merit, qualifications, and business needs. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other legally protected status under federal, state, or local laws.