8 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Testing and Development. • Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member. • Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation. • Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents. • Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2 and 2012. • Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor. • Knowledge of Relational Database Management systems. • Experience in Database Backup, Recovery and Disaster Recovery procedures. • Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and exception handlers. • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables. • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. • Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization. • Install and Configure SQL Server 2005, 2008, 2008R2 on Virtual Machines. • Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. • Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically. • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. • Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts. • Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc. • Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2000/2005/2008. • Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes. • Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence. • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill
26 freelance font une offre moyenne de $233 pour ce travail
Hi, I can deliver this project within a good timeframe. I would need to ask a few questions to clarify the scope. Please send me a message if you're interested. Thank you.
Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery :) Please inbox and we can discuss about project and I will re Plus
We are a team of excellent programmers and engineers. We have completed over 250 jobs up to now, and are ever-growing at rapid speed. Our team include many experts with following skills. - C/C++/C#/Java Programming Plus
I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my Plus
Hi there, if you'd really like to have a professional web app for your project , here is my introduction: I’m a programmer, a mathematician and a full time developer with a strong background developing a wide range of Plus
Hi, I have developed 100+ mobile application and 200+ websites and web application. I am experienced and hard-working developer with deep knowledge of Android, Java, AngularJS, Ionic, Cordova/phonegap, Meteor, Codei Plus
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and Plus
Hi, Delivering the task with quality is my goal. My skills fit perfectly to the kind of task you are looking for. In fact, I had delivered tasks to my satisfied clients that is related to this job. You can contact me Plus
Hello, I am having 11 Years of relevant .NET experience. I reviewed your requirement and can serve with ease and will provide you the robust solution and services even after successful release, so requesting to kindly Plus
hello there, am ready for your project we can do this together .................................................................................
Hi, I'm DB developer, I have been working with different DB manager, mySQL, Oracle, SQL Server and others. I'm interested in the project. Let's discuss the project to know your needs and estimated time. Hope we can w Plus
Hi... i read the descriptions and understand i will provide quality work according to your requirement in given time period i will work on our project until you satisfy i am professionally software engineer(P Plus
Hello, It seems I am the right guy for this job as I have been into data warehousing since 5 years and can surely help you put with a quality solution. Thanks!
Hi, I am data Scientist and CERTIFIED R *(expert level), SAS, SPSS (expert level) I have been using all the mentioned tool since more than 3 years on live research data. I assure you the best possible results I c Plus
Hey there! Welcome to Bitzage Technologies! Hope you are doing well. This is Asad, I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Why do I say that? Plus
having heavy hands on experience in Performance tuning and developing complex modules using SQL Server.
Hello my name is Vladimir I am certified MS specialist and have exoerience with customer from Germany Typically my rate is 15 $hr Regards