Database Developer - Intermediate/Senior Levels

Database Developer Job Purpose:

The Database Developer will be responsible for the design, development, and review of all database development activities to include implementation of new data schema, fields, or data values; Employing best database development knowledge to address performance, scalability, and efficiency issues with high transaction volume systems; configuring and testing new database features for our commercial and government clients.

Database Developer Job Duties include but are not limited to:

• Design database schema based on data modeling of business requirements and entities.
• Document schema design and maintain data dictionaries for all tables.
• Write new stored procedures, functions, views, triggers, constraints, etc.
• Review SQL code to ensure compliance to coding standards and best practices as well as maximum performance.
• Create deployment and rollback scripts for all database objects manually or auto-generated.
• Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.
• Troubleshoot performance problems and propose short term fixes and long term solutions.
• Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer.
• Work with Architects and lead developers to come up with optimal database design.

Skills/Qualifications:

• B.S. in Computer Science and 5+ years related experience.
• At least 5 years of hands on SQL Server development experience.
• Expert knowledge of all aspects of SQL Server 2012/2014/2016 Transact SQL including the ability to write and deploy effective triggers, stored procedures and user defined functions.
• Profound understanding of SQL Server concurrency features, transactions, and locking; Excellent data modeling and schema design skills, including normalization and de-normalization.
• Full grasp of the pros and cons of table partitioning and distributed partitioned views and how large data volume affects replication in SQL Server environment; In-depth knowledge and hands-on experience developing, deploying, and maintaining substantial SSIS packages.
• Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation; Ability to analyze disk space requirements and hardware utilization, automate error notification.
• Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc.
• Ability to conceptualize business and technical solutions and articulate ideas clearly and concisely. Self-starters that can take loosely defined assignments and drive them to structured work.
• Excellent verbal and written communication and interpersonal skills.

Send resumes to careers@iweb4ullc.com.