Example Of A Database - 863 Words

Profile Summary Database professional with ten years of IT experience Design and develop the mission-critical, highly available, high volume OLTP databases hosted in SQL Server and Oracle Highly proficient in T-SQL and PL/SQL programming languages for creating optimized stored procedures, functions, triggers, views with complex business logic Expertise in performance tuning and troubleshooting Hands-on experience in designing, building, deploying and supporting data integration with Microsoft BI using SSRS, SSIS, and DTS packages Thorough experience in database normalization and data modeling Experienced working in both Waterfall and Agile – Scrum/ Kanban development methodologies with a solid understanding of software†¦show more content†¦Reduced the response time from over a minute to less than three seconds A few complex batch processes were taking 15 to 20 hours each to complete and impacting the daily schedule. Isolated the components which were running slower an d tuned the related database code which reduced the processing time to about five times lesser Senior Software Developer, Apollo Education Group, Inc. Apr’12 till Mar’17 Responsibilities: Development of database packages and procedures for various complex business scenarios Working with upstream and downstream applications, write queries and procedures as per their requirements, create test data, and help them understand the business process and the data Part of a cross-trained team with participation in development, review, and testing Key accomplishments and recognitions: Migrated out of warranty SQL Server 2000/2005 databases into SQL Server 2012 within time frame and budget ensuring compliance and security of companys most critical student data Reduced complexity with multi-system dependency by converting more than 20 DTS packages into SSIS jobs used for aggregating data from heterogeneous systems for analysis and decision-making Re-engineered the program approval process for the University. Simplified the design used by application services and user interface Improved system performance by converting legacy codes into optimized SQL and PL/SQL packages which in turn saved company costsShow MoreRelatedDatabase Design Essay examples1204 Words   |  5 PagesDatabase Environment Brandon Smith DBM/380 10-8-2012 Kenneth Hoskins Database Environment â€Å"A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.† (tech-faq.com) To be useful over a long term the database should be ableRead MoreThe Evolution of The Database Essay example847 Words   |  4 Pagesrevolutionized information storage and retrieval. Thus the first databases where born. Flat File Flat file databases where the first of many database models, almost as old as the computer. Flat file databases stored data in text files saved in the file system. There was little to no organization, it was a step backwards in data organization. The only real befit was that data could be retrieved remarkable speed, when the database was used by a very skilled programmer. This created a new problemRead MorePhysical Database Design Lecture Exampl Essay example977 Words   |  4 Pagesï » ¿PHYSICAL DATABASE DESIGN EXAMPLES Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: The database keeps track of the history of all of the teams that each player has played on and all of the players who have played on each team. TheRead MoreDatabase Management Systems and the Growth of the Internet Essay examples1971 Words   |  8 Pages Recent inventions and technical advancements have changed the appearance and indeed, the entire capability of the internet as most people know it. Many events have contributed to this change, but none so much as the processing method known as Database Management Systems (DBMS). From its birth in the last century, the way computers process information has grown and expanded to a point that would have been hard to imagine for the early programmers. This growth actually spurred on the growth ofRead MoreWhat Are The Four Types Of Database And Their Pros And Cons1172 Words   |  5 PagesIntroduction: In this document I am going to explain what database is and then I am going to list four different types of database and their pros and cons (Advantages and Disadvantages) for all databases that has been listed. And finally I am going to give an example of each database when it can be used. What is a Database? A database is a group of data and ii is often shortened DB. They are mainly or normally used for two purposes. Storing data and sorting data. You can save different types ofRead MoreAssignment 2 Database Management Systems1167 Words   |  5 PagesAssignment-2 Database Management Systems General Database Concepts 1. Describe the types of facility you would expect to be provided in a multi-user DBMS. Data Storage, Retrieval and Update. A User-Accessible Catalog. Transaction Support. Concurrency Control Services. Recovery Services. Authorization Services. Support for Data Communication. Integrity Services. Services to Promote Data Independence. Utility Services. 2Read MoreAnnotated Bibliography On Non Relational Databases Essay1072 Words   |  5 Pagesof NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reasonRead MoreTypes Of Databases By Kazi Rashid Number1443 Words   |  6 Pagesknow: Types of Databases By Kazi Rashid number:RAS14002716 September 28 2014 This document contains all the information about the advantages and disadvantages of different database models. By Kazi Rashid â€Æ' 23/09/2014 Unit 21 Data Analysis and Design All about Databases Databases, we use them most of the time in our lives from organising files to storing music on our computers. What are databases? Databases are an organised way of storing data. Before computers many databases were stored inRead MoreDatabase Management Systems676 Words   |  3 PagesDatabase Management Systems A database management system (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, IBMs DB2, Microsoft Access, Microsoft SQL Server, MySQL, 4th Dimension and FileMaker. DBMSs are typically used by Database administrators in the creation of Database systems. DBMS enables the user to store, modify, and extract information from a database(Tenner, 2005). There are many different types of DBMSs, ranging fromRead MoreThe Features Of A Relational Database1585 Words   |  7 Pagesof a relational database. This is to be shown as a report or presentation and must discuss the following. †¢ Features: entities; attributes; relationships; †¢ Entities: primary keys, foreign keys; referential integrity; attributes; †¢ Attributes: field properties e.g. data types, size, validation rules †¢ Relationships: one-to-many; one-to-one; many-to-many Relational database – This is a database that contains more than one table of which are linked using key fields. An example could be a library