Hello Partner, Hope you doing great!
Immediate Need - Sr. SQL Developer - Interview and Start ASAP!! Job Title: Sr. SQL Developer Location: Washington, DC Duration: 6 Months Contract to Hire *Face to Face after Phone must Master Degree in Resume Must EAD GC, Green Card, US Citizen 9-10+ Years of Experience Must* Job Description The Lead 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 new releases. Will be a Subject Matter Expert (SME) and responsible for providing leadership in Database architecture and design to all cross functions in the department. Additional Responsibilities: Design database schema based on data modeling of business requirements and entities Document schema design in E-R diagrams using MS Visio and maintain data dictionaries for all tables Write new stored procedures, functions, views, triggers, constraints, etc. Review SQL code written by application developers 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 Qualifications B.S. in Computer Science and 10+ years related experience 6+ years of hands on SQL Server development experience Expert knowledge of all aspects of SQL Server 2008 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. Best Regards, Arnav Singh - Sr. Lead Recruiter ITBrainiac Inc Princeton Forrestal Village 116 Village Blvd, Suite 200 Princeton, NJ 08540 Work: 201-855-0253 Cell: 609-388-1604 ll *ar...@itbtalent.com <ar...@itbtalent.com> www.itbrainiac.com <http://www.itbrainiac.com>* -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.