Vacancy expired!
IKCON TECHNOLOGIES INC delivers exceptional IT services and solutions that provide clients with definite edge over competitors and promoting highest standards of quality. We are currently looking for a Sr SQL Server Functional / Application DBA with one of our clients in NYC, NY. If you are actively looking for opportunities, please send us your updated resume with your contact details. JOB TITLE Sr SQL Server Functional / Application DBA CITY NYC STATE NY On-Site Position TAX TERMS C2C/W2 EXPERIENCE 10 to 15 Years INTERVIEW MODE Telephonic/Video Teams Call Job Description: Must have 10+ years of experience working for US companies. Must have 4 + years of 'Recent' Banking experience (Since 2016). Must have recent experience performing Level 3 support (The highest-level Support). These positions are for a 'Global' unit. Consultants must have experience working 'Constantly' with DB's of 30TB or more (Not Less). Experience working with large-scale enterprise application setup across Data centers. Must have a Minimum of 10+ years conducting general database administration tasks (e.g., DB implementation, DB code deployments, DB backups, creation of DB user accounts). Minimum of 7+ years' experience working as a SQL Server DBA. Must have experience as a Functional & Application DBA. Must have at least 5 years administering database platform specific advanced features (e.g., Clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server database servers and SQL code. Minimum of 5+ years' experience working in a SQL DBA Role with multiple databases and SQL development experience. Proficient in MS SQL Server 2014 - 2019. SSIS Package creation and debugging skills. Stored procedure development and tuning. Data replication exposure. Indexes: When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes. Conduct SQL Server lunch-and-learn sessions for application developers. Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc). Consultant must have experience: 1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions. 2) Designing tables and picking datatypes of Using Profiler traces and other tools to find the most frequently run queries. 3) Using free tools like spBlitzIndex and DMV queries to answer questions about index usage. 4) On-call troubleshooting for SQL Server service outages. 5) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem. MINIMUM QUALIFICATIONS Bachelor's Degree in relevant domain is required, or Master's level degree preferred.