Job description
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.
Refer code: 8632364. I Web 4 U - The previous day - 2024-03-19 04:29