Robert J. DePaul & Associates, Inc. is looking for a candidate for the following position. If you qualify, please call 412-561-0417 or email your resume to hire@rjdepaul.com.
Need to have more depth on the database side, but still pushing the .NET Framework, C#, ASP.NET as well.
-Creation of logical and physical database designs (using ERD notation)
-Maintenance of physical databases
oInstallations and Upgrades of SQL Server 2005/2008 and Client Tools on Windows 2003/2008
oDeployment methods of SQL Server 2005/2008 (Mirroring VS RAID, best methods of deployment across disk). Internal disk, SAN disk.
-Installation and Maintenance of DB (Physical Database(s): Instances; Schemas; Tables; Views (Including partitioned and updatable views)
-Security Configuration: General Security Setup (Server Security/Database Security); Data Encryption/Decryption
-Regular Backup and Restoring Processes – Supporting development
-Code constructs with T-SQL – Strong skills
-Strong deployment of coding standards (T-SQL/ANSI-SQL)
-Data Access Layers (Using ADO.NET)
-Procedures
-Triggers
-Functions
-Performance Tuning
-Working on reconfiguration of database and code constructs to improve security
-Able to perform code walk-thru
-Other Products
-Integration with .NET Framework and data access
-SSRS - Reporting Services 2005/2008
-SSIS – Integration Services
-Service Broker
-Studio Management Tools
-Analytical
-Performance Tools (Microsoft or any 3rd party tools