Hi Folks,
Greetings of the Day!!!! My name is Shreshtha from Charter Global, Inc. This is very fast moving position with one of my Client , So please let me know if you have a good fit consultant , , Please provide me his/her resume with contact detail and send it to me at *[email protected] <[email protected]>* and reach me 770-326-9933*514 *Title: SQL Server Data warehouse DBA* *Location: San Diego CA* *Duration: 6 Months +* · Take the lead on our efforts for continuous integration and help us develop a proper process coupled with technology · Strong understanding of SQL Server ”under the hood” · Strong expertise in coding/reviewing/enhancing TSQL including enhancements from SQL 2012 · Monitor queries and indexes in production and suggest optimizations · Make suggestions and standards for proper filegroup usage and growth · Partner with the SAN team for data warehouse needs (LUN allocations, IOPS, spacing requirements and growth projections). · Work closely with the data warehouse architects and the data acquisition developers to ensure optimal data base and data extraction/loading process design for each implementation. · Document data movement and data loading processes & physical hardware architecture. · Maintenance of the data warehouse, including maintenance of the persistence layer, EDW layer, operational data store, data mart, metadata management, etc., and oversight of hardware/software configuration. · Continually ensures completeness and compatibility of the technical infrastructure and DW implementation to support system performance, availability and architecture requirements. · Maintaining CDC and replication from source systems for ODS consumption. · Install/configure SQL Server environments on physical, VMs and Azure. · Understand and are able to make recommendations for hardware to support a DW environment in SQL Server. · Keep up with emerging trends/technologies in the Microsoft BI landscape (i.e. SQL Server 2014, MS BI Stack, VS, etc.) · Monitors and maintains data quality including data validation, cleansing/scrubbing, etc. · Work with development team towards automation for continuous validation of data quality and Master Data Management. · Maintain alerting and triage system for data quality failures, long running queries during ETL batch loads and/or end user queries. · At least a basic understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data. · Management and maintenance of databases o Manage backups. o Test backups periodically to ensure recoverability. o Run Database Consistency Checks. o Review logs for errors periodically. o Update databases as needed for new development. o Assist development team with SQL performance o Work with development team to determine appropriate access permissions for groups of users. · Monitoring and optimization of databases o Use Performance Monitor, SQL Profiler, and 3rd party tools to gather performance data on server and database levels. o Tune indexes, queries, table structure, partition strategies and object placement for optimal performance · Other Functions: o Strong technical expertise in data storage/management technologies for DW solution o On-call troubleshooting for SQL Server service outages · Minimum Qualifications: o Bachelor's degree in IT preferred; Equivalent combination of education and experience may be substituted in lieu of degree o Six (6) years’ experience as an enterprise data warehouse DBA. o Excellent written and oral communication skills, with the ability to carry on successful interactions with both engineering and business teams. Thanks And regards. Shreshtha Sinha [email protected] www.charterglogal.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
