Database Developer

LCG is seeking a well-established Database Developer who has a good blend of technical skills in application design, development, and system integration to support an existing Federal government customer. This is an exciting environment with multiple large projects and upgrades on-going and planned over the next 2 years.

Essential Responsibilities:

• Model, design, develop and construct large relational databases or data warehouses.
• Optimize database performance by tuning queries, indexing, and implementing best practices.
• Collaborate with cross-functional teams to gather and analyze requirements for new projects and features.
• Create and optimize data models for warehouse infrastructure and workflow.
• Set standards for database operations, programming, query processes, and security.
• Write and deploy SQL queries and provide Oracle, SQL Server and MySQL database expertise to support legacy applications.
• Collaborate with software developers to understand application data requirements and design efficient database structures.
• Provide database management and SQL development support for all ITB initiatives.
• Ensure databases are designed in a manner that ensures maximum usability and value of the agency’s IT assets.
• Develop and maintain database documentation, including data standards and procedures.
• Collect, Record, and maintain accurate configuration information for all software and database configurations stored in configuration management tool.
• Provide database backup procedures, recovery systems, and SQL.
• Assist with schema design, code review, SQL query tuning.
• Altering storage structures to meet the evolving needs of the company.
• Setting up database user accounts
• Training users on how to access the information in the database.
• Finding and debugging malfunctioning programs affecting the database integrity.

Required Qualifications:

• Bachelor’s degree in computer science or a related information technology field
• 8 to 10 years of experience as a Database Developer and DBA Specialist
• Proficient installing, configuring, maintaining and upgrading Oracle and SQL databases
• Write complex SQL queries for data extraction, manipulation, and reporting.
• Perform database optimization, including query performance tuning.
• Shell scripting in Data Base Development
• Knowledge of JEE
• Experience with monitoring Database capacity and performance
• Experience with applying security patches and subsequent testing.
• Expert in Oracle, SQL Server database design, coding, and documentation.
• Ability to refresh or clone databases from production to development.
• Experience using stored Procedures, Functions, Triggers and packages.
• Experience provisioning Microsoft SQL server, Oracle and MySQL instances
• Experience with Microsoft SQL server clusters
• Experience with AppDynamics or other performance monitoring tool
• Experience interacting with users and customers regularly.